Data Flow Destination columns copying to Data Flow Transformation Output

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Data Flow Destination columns copying to Data...

Data Flow Destination columns copying to Data Flow Transformation Output

Rate Topic

Display Mode

Topic Options

Author

Message

brewmanz

Posted Monday, January 14, 2008 4:56 PM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, December 04, 2012 11:16 AM
Points: 477, Visits: 389

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 »

Permissions