SQL Server Management Studio

SQL Server Management Studio is the main tool used to manage SQL Server 2005 databases and run T-SQL queries against the tables and views. In this section, you will not learn how to use this tool to manage databases; instead, you will learn how to use this tool to connect to Integration Services service and manage Integration Services packages. So, instead of talking about the tool, let’s start using this tool straight away with a simple Hands-On exercise.

Hands-On: Connecting to Integration Services Service

In this exercise, you will connect to Integration Services and explore where DTS 2000 packages can be managed within SQL Server Management Studio.

Exercise (Using SQL Server Management Studio)
1.
Choose Start ...

Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.