SSIS and Sql Server Journey

Personal Notes of Sarabjit Singh and Bhavpreet Singh

Executing SSIS Package via command prompt using multiple config files

on March 20, 2013

Normally we have only one config file and this is how we execute the package via command prompt::

/FILE "F:PackageFolder\Package.dtsx" /CONFIGFILE "F:\ConfigFileLocation\FirstPackageConfigFile.dtsConfig" /CHECKPOINTING OFF  /REPORTING EW 

In case we have multiple config files this is how the command goes:

/FILE "F:PackageFolder\Package.dtsx" /CONFIGFILE "F:\ConfigFileLocation\PackageConfigFile.dtsConfig" /CONFIGFILE  "F:\ConfigFileLocation\SecondPackageConfigFile.dtsConfig" /CHECKPOINTING OFF  /REPORTING EW 

Hope it helps! 🙂


One response to “Executing SSIS Package via command prompt using multiple config files

Leave a comment