November 8, 2006 at 9:32 am
Hi
I need to import high volume of data from one database to another using SSIS.
But I need the following manipulation to be done while pumping the data:
Data is pumped from Database1.Table1 to Database2.Table1
Database1.Table1 has three columns as A,B,C
Database1.Table1.A will have two columns as A and D
Data pump design:
Database1.Table1.A will be pumped to Database2.Table1.A
Database1.Table1.B and Database1.Table1.C will be [String] concatenated and pumped to Database1.Table1.D
I am not sure how to concatenate the two columns value into the final destination one. Could any one kindly help me? Thanks in advance.
Regards
Utsab Chattopadhyay
November 8, 2006 at 10:13 am
It is a little confusing to understand what you are trying to do.
Can you not use a Derived Column in the data flow. Even better can you join the tables and base the Source on a SQL Command?
Regards
Daniel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply