Integration Services Development and Management Tools

Integration Services includes two studios for working with Integration Services

· SQL Server Data Tools for developing the Integration Services packages. that a business solution requires. SQL Server Data Tools provides the Integration Services project to create packages.

· SQL Server Management Studio for managing packages in a production environment.

SQL Server Data Tools

SQL Server Data Tools (SSDT) transforms database development introducing an abundant, declarative model. that spans all phases of database development inside Visual Studio. It uses SSDT Transact-SQL design capabilities to build, debug, maintain, and refactor databases. The work with a database project with a connected database instance on or off-premise.

Developers use familiar Visual Studio tools for database development. Tools such as code navigation, IntelliSense, language support that parallels. It is available for C#, Visual Basic, platform-specific validation and editing Transact-SQL editor. SSDT also provides a visual Table Designer for creating and editing tables.

The SQL Server Object Explorer in Visual Studio database SQL Server Management Studio. SQL Server Object Explorer allows doing light-duty database administration and design work. It creates, edit, rename and delete tables, stored procedures, types, and functions. the edit data, compare schemas or queries using SQL Server Object Explorer.

Working in SQL Server Data Tools (SSDT) 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 using the troubleshooting and monitoring features in SSIS Designer. the debugging features in SQL Server Data Tools (SSDT).

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

SQL Server Management Studio

SQL Server Management Studio provides the Integration Services service. that use to manage packages, running packages, and determine impact. The data lineage for Integration Services and SQL Server objects.

Working in SQL Server Management Studio perform the following tasks

· Create folders to organize packages in a way that is meaningful to your organization.

· Run packages stored on the local computer by using the Execute Package utility.

· Run the Execute Package utility to generate a command line. It uses to run the dtexec command prompt utility.

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