Next: More Lamentation On The State Of Democracy. Previously: A Glance At Military Commissions.

Easy SSIS Package Deployment

121 words.

Another in a series of random programming tips by Thomas Krehbiel, mostly to help me remember them in the future.

Probably everyone knew this but me, but I discovered (by peeking at someone else’s batch file) that you can run SSIS packages without any special deployment. Previously, I had been running the Package Installation Wizard (by double-clicking the .SSISDeploymentManifest file) to deploy my package to SQL Server as a File System package. Then I would run the package from the command line with:

dtexec /DTS "\File System\(project)\(package)\" ...

Little did I know that there’s also a /FILE parameter. So all you have to do is slap your package into a directory, and run it with:

dtexec /FILE "(package).dtsx" /CONFIGFILE "(config).dtsConfig" ...

Related

Next: More Lamentation On The State Of Democracy. Previously: A Glance At Military Commissions.

This page is a static archival copy of what was originally a WordPress post. It was converted from HTML to Markdown format before being built by Hugo. There may be formatting problems that I haven't addressed yet. There may be problems with missing or mangled images that I haven't fixed yet. There may have been comments on the original post, which I have archived, but I haven't quite worked out how to show them on the new site.

Sorry, new comments are disabled on older posts. This helps reduce spam. Active commenting almost always occurs within a day or two of new posts.