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 |
|
Blessed1978
Yak Posting Veteran
97 Posts |
 Posted - 2015-02-12 : 13:20:24
|
| I Would like to add these parameters to my existing SSIS package.what would be the steps in doing soWHERE ?=1 or datediff(d, ?, '1/1/1900') = 0 and datediff(d, ep.RUNDATE, getdate()) = 0 or datediff(d, ?, '1/1/1900') <> 0 --and datediff(d, ep.rundate, ?) |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2015-02-12 : 22:01:18
|
| you need build the query in a variable before you pass in to the data flow/execute sql. |
 |
|
|
|
|
|
ssis 2012 parameters