SSIS - How to read configuration values in script task code

Question

I have created a SSIS package which contains several dataflow and script tasks. Each script tasks contains input parameters for webservice calls which I need to make it configurable. I would also like to move the connection string to the configuration file so that I can have different connection strings for each enviorment. I have managed to create configuration using Package Configuration in SSIS. How do I read these configuration values in my script tasks. Could somebody help?

Tab Alleman · Accepted Answer · 2016-04-05 15:35:03Z

1

You have to assign the configuration values to package variables, and access the variables in your script.

answered Apr 5, 2016 at 15:35

Tab Alleman

31.8k7 gold badges41 silver badges54 bronze badges

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

1 Comment

PseudoToad Over a year ago

Thanks Tab! I'd mark this as the answer if I could!

Collectives™ on Stack Overflow

SSIS - How to read configuration values in script task code

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