Chapter 17. SQL Server Management Studio

IN THIS CHAPTER

SQL Server Management Studio Overview

Connecting to the Integration Services Server

Managing Packages

Using SQL Server Agent to Execute Packages

Configuring the Integration Services Server

“IT INCREASES THE NUMBER OF TIMES IT’S NOT GETTING CALLED.”—JAMES HOWEY

The chapters so far have mostly covered concepts pertaining to package internals and building packages in the design time environment. As the name implies, SQL Server Management Studio, or just Management Studio, provides the management functions for Integration Services. You’ll likely use the design tools for packages as they work their way through your development and testing processes. However, eventually, the packages ...

Get 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.