Deploy SSIS Packages

  • Article

If you are looking for a quick deployment utility for SSIS packages, the following can come handy:

set svr=%1

set src_fld=%2

set dest_fld=%3

for %%f in (%src_fld%*.dtsx) do dtutil /Q /Fi %%f /C "SQL;%dest_fld%/"%%~nf /DestS %svr%

Argument one for this script is obviously the server where you want it to be deployed. The utility uses Intergrated Security to authenticate the user.

Second argument is the path for all your dtsx files. Once you build the solution in VS 2005, you will typically find them in the bin folder and hence you argument will look like bin/  

You can leave the third argument as blank if you want the packages to be deployed to the root folder MSDB (which can be something different if you have modified the name of the root folder in the config xml file).

There a bunch of other really useful options but the above script does alleviate one of the pain points during development, testing and deployment.