setting config file for all packages in command

• chetanb3

  Newbie

  Points: 8

  More actions

  April 29, 2011 at 12:50 am

  #237428

  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?

• Orlando Colamatteo

  SSC Guru

  Points: 182293

  More actions

  April 29, 2011 at 12:52 pm

  #1317921

  Please don't double post.

  Direct replies here:

  http://www.sqlservercentral.com/Forums/Topic1100732-147-1.aspx

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato