Click here to Skip to main content
15,943,085 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to pass the varibles dynamically in ssis

1 solution


Various ways are there to pass variable into SSIS ETL package and set values to package variables.

Method 1:
1. Using SQL Table to store variable values and then Load variable value using Execute sql task to populate your variable.
Method 2 :
2. in C# code you can do this also

Try this:
Microsoft.SqlServer.Dts.RunTime.Variables myVars = package.Variables;

myVars["MyVariable1"].Value = "value1";
myVars["MyVariable2"].Value = "value2";

Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute(null, myVars, null, null, null);

Mubin Shaikh
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900