CODEWITHSUNDEEP
sql-serverssisetl
wilson_smyth
wilson_smyth

Reputation: 1506

is it possible to pass columns through an SSIS script transformation?

I have a source with 100+ columns. I need to pass these through a script component transformation, which altersonly a handful of the columns.

Is there a simple way to allow any columns i dont modify to simply pass through the transformation?

Currently, i have to pass them all in, and assign them to the output with no changes. This is a lot of work for 100 columns and id rather not have to do it if possible!

FYI: There is no unique key, so i cannot split out the records using multicast and merge them after the script component.

Upvotes: 3

Views: 1868

Answers (1)

KeithL
KeithL

Reputation: 5594

You actually have to choose what columns you want included in your script component as either read only or read/write.

Anything you do not select as read/write simply passes through.

There are things you can do with a script task. Like add an output column to your current data flow or even create a separate data flow output.

In your case. you will want to select the handful of columns that you want to alter as read/write, then modify those columns in script and the rest will just pass through.

Upvotes: 3

Related Questions