O'Reilly logo

MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide by Andy Warren, J. Steven Jones, Marilyn Miller-White, Victor Isakov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Identifying the SSIS Tools

The tools have changed from SQL Server 2000 as well. In SQL Server 7/2000, you designed and managed packages using Enterprise Manager. SQL Server 2005 now has SQL Server Management Studio (SSMS), which is used to manage not just SQL Server but also Integration Services, Reporting Services, and Notification Services. To design and maintain packages, you use another tool, BIDS. You deploy packages using DTExec.exe, DTExecUI.exe, or DTUtil.exe. Finally, if you want to edit DTS packages, you will still use the old DTS Designer, either by having a SQL Server 2000 instance on the same machine or by installing the feature pack.

You'll explore the tools in Exercise 6.1 by building and deploying a simple package from start to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required