DSXchange

job does not exactly looks like this.

I have many stages in my jobs some called parallelly and sequentially.

If I just put one sequecer then many links cross each other as well as go over stages. To make the job readable I was thinking adding more sequencer stages.

Keith, it is Sequencer stage in job sequences I am talking about.
I should have mentioned it clearly in the first place itself. Sorry for that.

Hi, In my job sequence, there are many jobs. If any of the job fails or generats warning, I need to call an Abort job that updates one of the process status table as 'Failed' for the process. The sequence has many job and from each we have added a custom condition (Abort or Warn) to the abort job. T...

In the job sequence enabling job property Add check points to seq and disabling property Automatically handle the activities that fail might help you.

If you use the Code to show the job design it would look much better and we would be able to understand it properly. So pls post your job design using Code option while posting.

Thanks for your input guys!!!

Hi guys, I have read the article from Vincent on SSIS and DS comparison and thank you Vincent for such a informative article on it. Currently we are planning to use SQL server as a DB and SSIS as ETL tool for one of our requirements. We will be getting around 10 M (million) rows every month and have...

Thanks a lot, Craig!!!

Before trying it out wanted inputs of some gurus like you people. I will post the result once it is done.

We have scripts with hard code server param in the dsjob command. Does this mean using dsenv we can avoid it?

Actually we want to run DS 7.5.1 on default port is because we wanna avoid any change in the script.

Thanks Craig! I just checked it!! The thing is - we have some scripts where we have hard coded server name. Now if the new DS install is on port number then these script will have to be changed and if possible wer want to avoid that change. So we were thinking of installing new DS again on the same ...

Ya Kumar!!!

We have to install both versions such that 7.5.1 should not override the 7.1 install. Ya so 7.5.1 will be installed at diff location on the same server.

Hi, We were earlier on DS 7.1 version. Now we want to move onto DS 7.5.1. One option we had is - install DS 7.5.1 on a separate box and then export/import jobs onto it. Rather than going for it, we were thinking of the following option: On the same box on which DS 7.1 is running (default port), take...

Whats the problem? Which DB stage you are using for writing the SQL?

Following XPaths should be used to generate this XML. /RadiantDocument/SupplierData/@SupplierEDINumber /RadiantDocument/SupplierData/@SupplierName /RadiantDocument/CreditMemoList/CreditMemo/@CreditMemoNumber so on... Define one empty column Item ProductCode as key column with XPath as /RadiantDocume...

The constraints are forced by resources available on your machine.
What kind of error messages are reported?