Hands-On Microsoft SQL Server 2008 Integration Services part 27. Deploy and manage high-performance data transformation solutions across your enterprise using the step-by-step techniques in this fully revised guide. Hands-On Microsoft SQL Server 2008 Integration Services, Second Edition explains the tools and methods necessary to extract conclusive business intelligence from disparate corporate data. Learn how to build and secure packages, load and cleanse data, establish workflow, and optimize performance. Real-world examples, detailed illustrations, and hands-on exercises are included throughout this practical resource. . | 238 Hands-On Microsoft SQL Server 2008 Integration Services In this example we used a UNC path to specify the location of the package. AIT is the name of the second server I m using to test Integration Services packages designed for this book. 4. Verify that the Mailing Opportunities package exists in the My SSIS Packages store dtutil EXISTS DTS My SSIS Packages Mailing Opportunities The DTS option specifies that the verification for existence of the package should be done on the SSIS Package Store. Note that the DTS option cannot be specified with the FILE SQL Server User or Password options. Exercise Copy SSIS Packages If you have used the COPY command of good old DOS this is still available at the command prompt but hardly anyone uses it now you will find copying packages quite the same. Using the DOS COPY command you provide the source path and name of the file to be copied and destination path and name of the file to be copied to. With dtutil you provide similar parameters but in a slightly more complex manner because multiple storage locations SQL DTS and FILE are involved here. The syntax for the COPY command is shown here dtutil SourceLocation SourcePathandPackageName COPY DestinationLocation DestinationPathandPackageName . Note that you do not use a backslash when you provide the destination location after the COPY command. 5. You have saved your package in the file system while designing the package using BIDS. Now you want to copy your package from the file system to the MSDB database of the SQL Server named W8KR2 in my case . dtutil FILE C SSIS Packages Mailing COPY SQL - Mailing Opportunities DestS W8KR2 If you still have the Mailing Opportunities package saved to the MSDB database of your server you will see a confirmation prompt Package Mailing Opportunities already exists. Are you sure you want to overwrite it Typing Y will overwrite the package and typing N will cancel the command. To stop such confirmation prompts you can use .
