Home All Groups Group Topic Archive Search About
Author
13 Jul 2006 9:37 PM
Mitch
I am designing my first DTS pkg in SSIS Designer.  I am in
the Data Flow tab.  I have created a 'box' that successfully
connects to an Excel worksheet named range (table) on my
network.  It connects to another 'box' for data conversion
in which I recast the data types and rename (output alias)
all input columns.  I need to copy the recast columns from
the data conversion step on to a SS database table.  My
problem is that the output from the data conversion step
includes both the input to that step AND the output from '
that step.  HOW DO I EXCLUDE THE DATA CONVERSION INPUT COLUMNS
FROM THE OUTPUT FROM THE DATA CONVERSION STEP?

AddThis Social Bookmark Button