DSXchange

I guess it might be the lengh issue. When i used lengthy invocation id , i got the same error.

Datastage cant find this file name at all.

Let us know the detail info like, what you have mentioned in the stage level.

Then it will be easy to guide.

DS User

Hello All

I created a Parallel Stage type (CUSTOM) and it is working fine. Is there is any way to make this job as a Read Only Job to the rest of the users?

Thanks
DS User

Please share the warning message

Thanks craig

I used Trim(R) to take out the last delimiter and it worked fine.

Thanks

DS User

Hi All I did a Looping job. job design, Command Activity --> UserVariable Activity --> StartLoop --> Routine Activity --> EndLoop Command Activity will read a .csv file (cat filename) file is having the below values. One| Two| UserVariable Activity (Convert(@FM,'', ReadSourceData.$CommandOutput)) In...

Hi Andy Sorrell Thank you very much for your valuable reply. Hereafter I will try to post as much as I can. I will follow as you guided. Yes I need RCP and Multiple Instance. My source is going to create new tables at all time (each table relates to a device. If new device installed, then few tables...

Hi Thanks for the reply. You are right, I should give more details. But in this case, I don't have much as I am not getting any warning / error. Anyhow I will explain it in detail. Herewith my job design. SQL Server | SQLServer ----> Checksum ----> DiffStage----> TFM ---->SQL Server RCP enables for ...

Hello All

I did a job using RCP to find difference for before and after datasets using Difference stage. Job is working fine, but DiffCode value is 28416 for insert records. I am not sure why I am getting this value ?

Please give some suggestions in this.

Thanks
DS User

Apologies for the delay to reply for this post. I did my own custom stage to handle this situation.

Thanks
DS User

If you use Change Capture, work will be straight forward.

If you use join & tfm then you need to build your own conditions, null handling.

You wont find much difference.

otherwise, get the checksum and compare that.

DS User

I tried it from 8.5 to 8.1 but no luck. I might missed something..

Still it wont allow to import again:)

Create a table having Batch id and col with int to handle it. then apply logic

Hi there


Is it possible to use RCP for the stages like Join, lookup, CDC etc?

I am trying to impliment RCP for my job design.

Source and Reference: SQL Server tables
Using full outer join and then load into file.

How this can be handled using RCP?

Thanks
DS User