question

bhavpreet avatar image
bhavpreet asked

Providing multiple config files while executing SSIS package

Hi All, I had a senario where I have to provide multiple config files while executing package using the command as below. /FILE "E:\PackageFolder\PackageName.dtsx" /Conf "E:\ConfigFile\PackageConfigFile.dtsConfig" /CHECKPOINTING OFF /REPORTING E Please guide how I can specify multiple configFiles?
sql-server-2008ssisdynamicpackage
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
bhavpreet avatar image
bhavpreet answered
Found the solution :) This is how it can be done: /FILE "E:PackageFolderPackageName.dtsx" /Conf "E:ConfigFilePackageConfigFile1.dtsConfig" /CONFIGFILE "E:ConfigFilePackageConfigFile2.dtsConfig" /CHECKPOINTING OFF /REPORTING E Thanks.. ---------- Regards Bhav http://ssisdevelopers.wordpress.com
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.