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
Posted

1 solution

Hi,

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);

Regards,
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