|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SSIS data flow designI 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? |
|||||||||||||||||||||||