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 |
|
chetanb3
Yak Posting Veteran
52 Posts |
 Posted - 2011-04-29 : 02:09:07
|
| I have four SSIS packages, one master and other are child packages.I am calling master package in sql server job. I have added Operating system(CmdExec) job step to execute packge through dtexec."C:\Program Files\Microsoft SQL Server\90\DTS\Binn\dtexec.exe" /SQL "\Master" /SERVER Myserver /CONFIGFILE "c:\dtsConfig\test.dtsConfig"I have specied the config file as shown above, when i execute the job the child packages are not picking up the files..Any idea how can i specify same config file in above command? |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-05-06 : 11:25:28
|
| Hi,I have a question whether you using execute package task in your master to call child packages.if so,i too working in the same situation,where i found that if you are not passing the variables from the parent to child then instead of using execute package task you can use execute process task and take the executable as the child package and pass configuration it might works.Thanks |
 |
|
|
|
|
|
setting config file for all packages in command