Introduction
When you develop a package in Business Intelligence Development Studio (BIDS), you can save this package to the file system, inside a table in the SQL Server, or in the SSIS package store. You will then use SQL Server Management Studio to run, monitor, or manage these packages from these locations. SQL Server Management Studio provides these management capabilities using Integration Services (SSIS) service. Using this service you can manage SSIS packages on local or remote servers. Integration Services service lets you stop and start SSIS packages, monitor running packages, import and export of packages, manage and customize the package store. This service is available only in SQL Server Management Studio, which means that you must ...
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.
