Export (0) Print
Expand All
0 out of 3 rated this helpful - Rate this topic

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.