Friday, June 22, 2007

SSIS Package Automation (DTutil)

I was putting together a deploy script for a project I have been working on the includes a series of SSIS packages developed using Visual Studio Business Intelligence Studio. After a bit of googling I discovered the way to automate the deployment of these was with a command line utility called dtutil.

You can move SSIS packages around from any sort of store to another. Here is a basic example that involves copying a package from a a file location (perhaps your deploy folder?) to the default sql server instance on the machine you run the command from.

Note that the /Decrypt option is for password encrypted packages built using the technique described in a previous post.

dtutil /FILE MyPackage.dtsx /COPY SQL;MyPackage /Decrypt myEncryptionPassword

No comments: