I need to pass values to the variables in a SSIS package at run time. Obviously it is not practical to open BIDS and set a variable every time the package needs to be run. We run it on SQL Server 2008 R2.
What is the best way to do that?
For example we have 3 variables used in the package. 1 of them are populated in the packages on fly, the other 2 needs to be specified from begining:
Let's say we have these variables defined in the package:
@Rec_Count (No need to set a value at run time - it will be populated by a dataflow automatically)
@Fetch_Size (Should be set a value when the package is kicked off)
@File_Path (Should be set a value when the package is kicked off)
How can we set the last two variables in run time by the user?
Thank you in advance.