Monday, May 23, 2011

SSIS Package Deployment via CMD

1. Copy SSIS Packages into specific folder e.g: d:\mssql\ssis\SSIS_Packages
2. Please type cmd in Run and then execute the below statements

3. DTUTIL /FILE d:\ app\ssis\SSIS_Packages\mypackage.DTSX /COPY SQL;mypackage /QUIET

 
SSIS Package Deployment Check


Connect to “SQL Server Integration Services” and you should see the SSIS Packages similar to the below.

 mypackage