Integration Services and SQL Server Management Studio

Integration Services includes SQL Server Management Studio for managing and monitoring running packages in a production environment. For more information, see Using SQL Server Management Studio.

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 (dtexec.exe).

  • Import and export packages to and from the SQL Server msdb database, the SSIS Package Store, and the file system.

For more information, see Administration (Integration Services).