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