Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Data Flow Destination columns copying to Data Flow Transformation Output Expand / Collapse
Author
Message
Posted Monday, January 14, 2008 4:56 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, June 16, 2014 4:03 AM
Points: 488, Visits: 403
Preamble
=======
I want to take one Table and transform its Columns into another Table - many times for different tables. Each Table's Columns are completely independently named. I am using a Data Flow Transformation Script Component to do this.
The (extremely simplified) Script would look something like:

Dim sa() as string
'Col43 is one of 50 to 90 input columns
'Name1, Name2, Name3 = 3 of 50 to 90 output columns
sa = Row.Col43.Split(',')
Row.Name1 = sa(0)
Row.Name2 = sa(1)
Row.Name3 = sa(2)

Problem
======
My problem is ... how can I get those columns from the Data Flow Destination - OLE DB Destination AUTOMATICALLY mapped into the Data Flow Transformation - Script Component, ready to use?

Currently I'm typing them one at a time (anywhere from 50 to 90) in Script Transformation Editor - Inputs and Outputs - Output 0 - Output Columns - Add Column with Datatype/Length, whilst looking at the Destination Table definition.

There HAS to be way to automate this ... isn't there?
You know - a "copy OLE DB Destination External Columns to Script Transformation Output Columns" button?

TIA

Brewmanz
Post #442768
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse