SQL Server Integration Services: Difference between revisions

Revision as of 05:33, 14 December 2012

Revision as of 05:39, 14 December 2012

Line 1:

[[Special:Contributions/115.186.57.76|115.186.57.76]] ([[User talk:115.186.57.76|talk]]) 05:39, 14 December 2012 (UTC)'''SQL Server Integration Services''' ('''SSIS''') is a component of the [[Microsoft SQL Server]] database software that can be used to perform a broad range of [[data migration]] tasks.

'''SSIS''' is a platform for [[data integration]] and [[workflow application]]s. It features a fast and flexible [[data warehouse|data warehousing]] tool used for data extraction, transformation, and loading ([[Extract, transform, load|ETL]]). The tool may also be used to automate maintenance of SQL Server databases and updates to '''multid'''imensional [[OLAP cube|cube data]].

Line 6:

==Features==

The '''S'SSIS''S'''IS''' Import/Export [[Wizard (software)|Wizard]] lets the user create packages that move data from a single data source to a destination with no transformations. The Wizard can quickly move data from a variety of source types to a variety of destination types, including text files and other SQL Server instances.

Developers tasked with creating or maintaining SSIS packages use a visual development tool based on [[Microsoft Visual Studio]] called the SQL Server [[Business Intelligence Development Studio]] (BIDS). It allows users to edit SSIS packages using a drag-and-drop user interface. A scripting environment in which to write programming code is also available in the tool. A package holds a variety of elements that define a workflow. Upon package execution, the tool provides color-coded, real-time monitoring.