Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2009-09-17 : 04:23:56
|
| Is there any possibility to pass a parameter to a SSIS package that limits the resultset as below.1. You choose from a combobox or pass parameter direct to package and this parameter is then used inside the dataflow to export to CSV the result.You pass "1" as parameter and the the Dataflow will use a query like below:set @param = 1select * from table1 where category like @param |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-17 : 04:37:55
|
| You can use a variable. And pass a variable in the command line call of the package.The following is an example of executing a package and providing a new value for a variable:dtexec /f mypackage.dtsx /set \package.variables[myvariable].Value;myvalue |
 |
|
|
|
|
|
parameter to SSIS job