Automatically Adding Columns to an SSIS Script Component

Question

I have a datasource whose output is connected to a Script Component. When i add some columns to the datasource. I should go to Script component and check the newly added columns as inputs. Is there any way that i can automate this process.

It should automatically select the inputs when ever there is a change in the Data Source columns.

See meta.stackexchange.com/questions/2950/…

John Saunders
– John Saunders

2011-09-08 20:09:02 +00:00
Commented Sep 8, 2011 at 20:09 — John Saunders
– John Saunders, Commented Sep 8, 2011 at 20:09

Joost · Accepted Answer · 2011-09-12 14:39:29Z

0

Sorry that's not possible with the Script Component in SSIS.

answered Sep 12, 2011 at 14:39

Joost

1,9313 gold badges20 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user922330 Over a year ago

Is there any other way to do this in SSIS. I have a dataSource table which adds new columns frequently. How can i get all the newly added columns eachtime with out editing the package?

Collectives™ on Stack Overflow

Automatically Adding Columns to an SSIS Script Component

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related