Skip to content

Latest commit

 

History

History
61 lines (40 loc) · 3.67 KB

integration-services-ssis-development-and-management-tools.md

File metadata and controls

61 lines (40 loc) · 3.67 KB
Raw
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic helpviewer_keywords
Development and Management Tools
Integration Services (SSIS) Development and Management Tools
chugugrace
chugu
maghan
10/14/2022
sql
integration-services
conceptual
studio environments [Integration Services]
tools [Integration Services], Business Intelligence Development Studio
Business Intelligence Development Studio, Integration Services in
SQL Server Management Studio [Integration Services]
SSIS, studio environments
SQL Server Integration Services, studio environments
tools [Integration Services], SQL Server Management Studio

Integration Services (SSIS) Development and Management Tools

[!INCLUDEsqlserver-ssis]

[!INCLUDEssISnoversion] includes two studios for working with packages:

SQL Server Data Tools

Working in [!INCLUDEssBIDevStudioFull], you can perform the following tasks:

  • Run the [!INCLUDEssNoVersion] 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 [!INCLUDEssIS] Designer, and the debugging features in [!INCLUDEssBIDevStudioFull].

  • 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 [!INCLUDEssNoVersion] msdb database, the [!INCLUDEssIS] Package Store, and the file system.

For more information about [!INCLUDEssBIDevStudioFull], see SQL Server Data Tools.

SQL Server Management Studio

[!INCLUDEssManStudioFull] provides the [!INCLUDEssISnoversion] service that you use to manage packages, monitor running packages, and determine impact and data lineage for [!INCLUDEssISnoversion] and [!INCLUDEssNoVersion] objects.

Working in [!INCLUDEssManStudioFull], 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 you run the dtexec command prompt utility (dtexec.exe).

  • Import and export packages to and from the [!INCLUDEssNoVersion] msdb database, the [!INCLUDEssIS] Package Store, and the file system.