Post reply

setting config file for master and chile packages in dtsexec command

  • April 29, 2011 at 12:25 am

    #238690

    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?

  • April 29, 2011 at 7:18 am

    #1317796

    Since the child packages are not started directly, you should use package configurations to configure those packages, instead of manually linking a config file to them.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply