CODEWITHSUNDEEP
c#visual-studio-2010parametersssisparameter-passing
Bal
Bal

Reputation: 81

Pass Variables to Project Parameters in SSIS

I am new to this network. Hoping I'll find an answer to this problem.

I have a SSIS Project with multiple Packages which are using the Project Parameters. I am trying to update the Project Parameters e.g. @PeriodStart: 2014-05-31. I can't find a way to dynamically write to the Project Parameter.

I am using Visual Studio 2010 in 4.0 Framework. Please can anyone shed light on this ?!

Kind Regards Bal

Upvotes: 6

Views: 14169

Answers (1)

Robert Anderson
Robert Anderson

Reputation: 1256

Project parameters are read only. What you are after is to assign variables depending on the project parameters and then read the variables. An overview of variables and parameters is here:

http://social.technet.microsoft.com/wiki/contents/articles/22194.use-ssis-variables-and-parameters-in-a-script-task.aspx

For example, you could add a script task to the control flow and then read in the project parameters, assign a readwrite variable to the script task and then use this variable.

Upvotes: 6

Related Questions