CODEWITHSUNDEEP
ssissql-server-2008-r2
Bilal Saeed
Bilal Saeed

Reputation: 603

How can we change the configuration information at runtime in SSIS?

Config files are loaded in the start and I want to know where and how are they stored in the memory, because according to my understanding, files are loaded once and the information in them are stored in some variables, I want to know how can I change the values of those variables at run-time?

Upvotes: 3

Views: 116

Answers (1)

Diego
Diego

Reputation: 36126

Like you would change the value of any variable. Your config file will only tell the initial value of the variables you set to be loaded from it. Once the package starts you can manipulate the variables with a script task for example:

 Dts.Variables("YourVar").Value = True

Upvotes: 2

Related Questions