MSSQL - How To Run SSIS From Command Line
Very Quick demo on how to run SSIS from the command line. See below for the Parameters used in the video for Cut and Paste.
PATH=%PATH%;C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtexec.exe
/FILE "C:\Temp\ConfigExample.dtsx"
/CONFIGFILE "C:\Temp\ConfigExample.dtConfig"
/CONNECTION "OLEDB-Connection-AdventureWorks;Data Source=SOUNDWAVE\SQL1;Initial Catalog=AdventureWorks2008R2;Provider=SQLNCLI10.1;Integrated Security=SSPI;"
dtexec /FILE "C:\Temp\ConfigExample.dtsx" /CONFIGFILE "C:\Temp\ConfigExample.dtConfig" /CONNECTION "OLEDB-Connection-AdventureWorks;Data Source=SOUNDWAVE\SQL1;Initial Catalog=AdventureWorks2008R2;Provider=SQLNCLI10.1;Integrated Security=SSPI;"