August 14, 2007 at 1:16 am
Hi pals,
I am new to SSIS packages.
I am using a dataflow task in my SSIS package.
I have a src OLE DB connection and a target OLE DB connection.
Inbetween them i have used the copy column transformation followed by a script transformation.
This is because i am not copying all the caolumns coming from to destination.
Instead i am filling some target table column values from global variables.
I connected the workflow from src--->copy column transfrmaton---->script component-->target ole db connection.
Here is my doubt.
When i double click my target connection,go to Mappings tab, i am getting two sets of input columns,
One set with original column names and other set columns prefixed with "Copy of xxxx".Which set do i need to connect to the
target table.
Can anyone help me out.
Regards,
franky
August 14, 2007 at 3:10 am
you donot need the copy coloumn transformation(it wil make another copy of the column). What you do is edit you sorce oledb and select columns on the left. Just tick the columns you wish t0 copy and untick the ones you dont.
Tip. it is alway a good idea to only have the columns you are handling in your transformation selected as ssis processes transformations in memory so unwanted columns dont get loaded and the transformation is quicker.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply