Integration Services and Studio Environments
Microsoft SQL Server 2005 includes two studios for working with Integration Services: Business Intelligence Development Studio, for developing the Integration Services packages that a business solution requires, and SQL Server Management Studio, for managing packages in a production environment. For more information, see SQL Server Management Studio and Business Intelligence Development Studio.
Business Intelligence Development Studio provides the Integration Services project in which you create packages, their data sources, and data source views.
Working in Business Intelligence Development Studio, you can perform the following tasks:
- Run the SQL Server Import and Export Wizard to create basic packages that copy data from a source to a destination.
- Create packages that include complex control flow, data flow, event-driven logic, and logging.
- Test and debug packages by using the troubleshooting and monitoring features in SSIS Designer, and the debugging features in Business Intelligence Development Studio.
- Create configurations that update the properties of packages and package objects at run time.
- Create a deployment utility that can install packages and their dependencies on other computers.
- Save copies of packages to the SQL Server msdb database, the SSIS Package Store, and the file system.
For more information, see Designing and Creating Integration Services Packages
SQL Server Management Studio provides the Integration Services service that you use to manage packages and monitor running packages.
Working in SQL Server Management Studio, you can perform the following tasks:
- Create folders to organize packages in a way that is meaningful to your organization.
- Run packages that are stored on the local computer by using the Execute Package utility.
- Run the Execute Package utility to generate a command line to use when running the dtexec command prompt utility.
- Import and export packages to and from the SQL Server msdb database, the SSIS Package Store, and the file system.
For more information, see Administering Integration Services