SYNCHRONOUS DATA TRANSFORM USING SCRIPT COMPONENT

[katbear]

Hello,

This should be a fairly simple question.

I have a flat file that is to be inserted into a table. However, before the data can be inserted, several transformations need to take place.

Most of the transformations will need to be scripted, as they are not stock transformations.

My question is, how do I set up my Input, Inputs and Outputs columns in the Script Transformation Editor for the script component?

Under input columns, I have checked all the columns in the file that I will need. But then, under Inputs and Outputs, I am confused as to whether or not I need to set up OUTPUT columns for each of the input columns from the file?

The data flow is synchronous. That is, the number of columns/rows IN = number of columns/rows OUT. It's just that data rows from the file will be modified a little before going to the table.

For example, for cols 1 - 10, perform a scripted transformation. But, for columns 12 - 20, don't do anything. Just insert into the table as-is. Then for columns 21 - 30 do something else, and so on.

So my QUESTION is, how am I supposed to set this up in both my script and in the Script Transformation Editor?

That is, what do I need to do on the script level to get the rows "out" to my table? Or does this take place in "mappings" or what?

Very confused.

Thanks

 

[MDXer]

This should help get you started.
The Script Component(As A Transform)

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[katbear]

Thanks mdXer, I will look at the link.

Through a series of trial and error, etc I was able to figure out what I'm doing.

So far I have found nothing in SSIS is that hard, IF you know what to do, it's the knowing what to do that's really hard.