CODEWITHSUNDEEP
ssis
Tom
Tom

Reputation: 8681

SSIS - How to read configuration values in script task code

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?

Upvotes: 1

Views: 1737

Answers (1)

Tab Alleman
Tab Alleman

Reputation: 31785

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

Upvotes: 1

Related Questions