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

Using SSMS with SSIS

You use SSMS to administer SQL Server along with its optional components, Notification Services, Reporting Services, and of course SSIS. Figure 6.2 shows how to connect to SSIS.

FIGURE 6.2 Connecting to SSIS in SSMS

images

When you click Integration Services, you'll get the standard dialog box that asks you to choose from Windows or SQL Server credentials. Once authenticated, you should see that Integration Services has been added to the SSMS view (see Figure 6.3).

Looking at the Stored Packages folder, you can see two subfolders, one for the file system and one for MSDB, the latter being where you deployed the first practice project ...

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