Skip to content

Instantly share code, notes, and snippets.

@troyscott

troyscott/dtexec_multiple_configs.bat

Created February 15, 2013 17:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save troyscott/4961930 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save troyscott/4961930 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dtexec_multiple_configs.bat
@ECHO OFF
SET DTEXEC_PATH="C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtexec.exe"
SET PACKAGE_PATH=C:\project\ssis\
SET PACKAGE_LOG="DTS.LogProviderTextFile;MyLogConnection.txt"
SET PACKAGE_CONFIG=C:\project\config\
%DTEXEC_PATH% /FILE %PACKAGE_PATH%MyPackage.dtsx /LOGGER %PACKAGE_LOG% /CONFIG %PACKAGE_CONFIG%MyFirstConfig.dtsConfig /CONFIG %PACKAGE_CONFIG%MySecondConfig.dtsConfig
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment