Run Package in 32 Bit or 64 Bit Mode from Command Prompt
On a 64 bit OS, the default path to the 64 bit would be “c:Program FilesMicrosoft SQL Server100DTSBinnDTExec.exe"
Still on 64 bit OS, the path to the 32 version would be “c:Program Files (x86)Microsoft SQL Server100DTSBinnDTExec.exe"
Following is the code to run an SSIS package from command prompt:
1. RUN In 32 Bit mode:
“c:Program Files (x86)Microsoft SQL Server100DTSBinnDTExec.exe" /file C:PackageFolderPackage.dtsx /CONF C:ConfigFile.dtsConfig
2. RUN In 64 Bit mode:
“c:Program FilesMicrosoft SQL Server100DTSBinnDTExec.exe" /file C:PackageFolderPackage.dtsx /CONF C:ConfigFile.dtsConfig