Below is the sample package of using parameters in SSIS:
1. Create a package as shown below:
2. Create variables as shown below:
3. Configure Execute SQL Task as shown below, in SQL query replace parameter with '?' symbol.
4. Go to Parameter Mapping and configure as given below:
When you going to pass the parameter value in to SQL command then you need to chose 'Input' as Direction. In this package I want to get Max(SalesID) as an output so I have selected 'Output' as Direction. Simillarly if you are using more than 1 parameters than you need to number the parmeter from '0, 1, 2....'.
5. Now go to th eproperties of "SelectData" variable and configure expression field as shown below:
6. Now you can use the variable "SelectData" in any of your Data Flowsources to retrive the data from table.
No comments:
Post a Comment