Summary
SQL Server 2005 provides several tools that enable you to manage Integration Services and Integration Services packages effectively and easily. You started this chapter by enabling the SSIS service and then learned how to manage storage locations for storing Integration Services packages. You’ve used SQL Server Management Studio and dtutil to manage storage and Integration Services packages. You also learned how to import and export an Integration Services package from one storage location to the other. In the process, you created a new storage location on the file system for these packages. You learned about various tools to run an Integration Services package that include the use of the Package Execution Utility and the DTExec command ...
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.
