Dtutil Utility
You have worked with Integration Services from within SQL Server Management Studio and have imported and exported your SSIS packages with the help of GUI tools. Having used these tools, you have realized how easy it is to manage your Integration Services packages from the tools’ GUI. However, sometimes you need a command-line tool to write scripts to do the work in batches, you may want to automate tasks, or perhaps you want to schedule jobs. In this section you will learn how to manage Integration Services packages using Dtutil, a command prompt utility provided with SQL Server 2005.
Dtutil can be used for the following:
Verifying the existence of a SSIS package
Copying SSIS packages
Moving SSIS packages
Deleting SSIS packages
Signing ...
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
