March 8, 2006 at 4:16 am
Hello,
I have 5 tables/entities at my source end (i.e. MS SQL), now what i have to do is to copy records from different columns (i.e. columns from those 5 entities) and then i will have to paste those columns at my destination end (i.e. MYSql) in 3 different entities. Now i am doing this mechanism through Transform Data Task. Its very simple if i have to copy records from 1 table to another but here i have 5 tables at the source end and 3 at the destination. All this has to be done with TRANFORM DATA TASK. Do you have any suggestion?
Thanks
March 8, 2006 at 5:31 am
You could write three views at the source end that combined the 5 down to 3 and then select from the views.
March 8, 2006 at 6:12 am
hay thankx allen... thts a great idea.. let me work over it.. ok tell me one more thing..
"can i use 1 view at the source end against 3 tables at the destination end in a single package"... is tht possible .. if yes then give me some hint.. thankx
March 8, 2006 at 7:02 am
You could use one view to join the data together but you would need three transform steps in the package. Each one would take data from the view and insert into a single table. Obviously each transform step would only use some columns from the view.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply