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