On a 64 bit OS, the default path to the 64 bit would be
"c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe"
Still on 64 bit OS, the path to the 32 version would be
"c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe"
Following is the code to run an SSIS package from command prompt:
1. RUN In 32 Bit mode:
[code]
"c:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /file C:\PackageFolder\Package.dtsx /CONF C:\ConfigFile.dtsConfig
[/code]
2. RUN In 64 Bit mode:
[code]
"c:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe" /file C:\PackageFolder\Package.dtsx /CONF C:\ConfigFile.dtsConfig
[/code]
No comments:
Post a Comment