Endgame Viable
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" ...
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.