Hi,
Using SSIS, how is it possible to execute another ssis package and pass a parameter to it?
For example, I would like to have a sql code that runs the package say "d:\sysappl\CEM\SSIS\CSA.dtsx" and pass a parameter of fileName because the CSA.dtsx package requires a filename.
Something like:
execute "d:\sysappl\CEM\SSIS\CSA.dtsx", varfileName
Thanks
You can use an Execute Process task to execute DTEXEC.exe. If you search for DTEXEC.EXE on Microsoft's site, you'll get a page with all of the parameters necessary to do what you desire.
Or, you can use an Execute Package task along with Parent Package Configurations to pass down a variable value.
No comments:
Post a Comment