DSXchange

do you hav more than 1 row for the primary key combination in the dataset and the job execution mode is parallel ?

If you are using the big table in the 4 jobs , after the table is loaded you can do collect stats on the table before starting the jobs

Welcome aboard. You're wrong. It can be done in the one sequence, precisely as datisaq outlined. ... because in one of our job , we have the following sequence shell script to update the <param1> --> job that use <param1> but the job was using the old value (i.e. the value before the sequence has s...

Trim(col,"0",'L') will work with string data types(varchar..) and not with decimal Could you please anybody explain how to remove the Zeros with Decimal datatype: I am having source Col with Datatype decimal[20,2] i am getting data for example 000000000000000038.50 but i want to make targe...

This can't be done from the same sequence. Because the value of the parameter will be initialized when the sequence start .If it is changed in the sequence, it will not reflect.Gurus, correct me if i am wrong This you can do at a job sequence level. Main sequence:- Job1----->ExecCommand---->job2 In ...