SQL Server Integration Services: Difference between revisions

Revision as of 18:24, 24 April 2011

Revision as of 17:28, 10 May 2011

Line 1:

'''SQL Server Integration Services''' ('''SSIS''') is a component of the [[Microsoft SQL Server]] database software whichthat can be used to perform a broad range of [[data migration]] tasks.This is the fastest ETL tool available now.{{Citation needed|date=April 2011}}

'''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 multidimensional [[OLAP cube|cube data]].

Line 6:

==Features==

The SSIS '''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.

; Connections : A connection includes the information necessary to connect to a particular data source. Tasks can reference the connection by its name, allowing the details of the connection to be changed or configured at runtimerun time.

; Tasks : A task is an atomic work unit that performs some action. There are a couple of dozen tasks that ship in the box, ranging from the file system task (which can copy or move files) to the data transformation task. The data transformation task actually copies data; it implements the ETL features of the product.

; Precedence constraints : Tasks are linked by precedence constraints. The precedence constraint preceding a particular task must be met before that task executes. The runtimerun time supports executing tasks in parallel if their precedence constraints so allow. Constraints may otherwise allow different paths of execution depending on the success or failure of other tasks. Together with the tasks, precedence constraints comprise the '''workflow''' of the package.

; Event handlers : A workflow can be designed for a number of events in the different scopes where they might occur. In this way, tasks may be executed in response to happenings within the package —such as cleaning up after errors.

; Variables : Tasks may reference variables to store results, make decisions, or affect their configuration.

Line 61:

* [http://msdn.microsoft.com/en-us/sqlserver/cc511477.aspx SQL Server Integration Services Resources]

* [http://social.technet.microsoft.com/Forums/en/sqlintegrationservices/threads SQL Server Integration Services Discussion Forum]

* [http://www.sqlis.com/ SQLIS.com]

* [http://www.bi-dw.info/microsoft-ssis.htm SSIS resources]

* [http://www.cozyroc.com/search-scripts/ SSIS Scripts]

* [http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx SQL Server 2005 version comparison]

* [http://pragmaticworks.com/Products/Business-Intelligence/DTSxChange/DTSxChange-Download.aspx SQL Server Integration Tools]

* [http://ssisctc.codeplex.com/ SSIS Community Tasks and Components]

* [http://www.gerasus.com/ SSIS package search and documentation tool, SSIS-DTS Package Search]

* [http://pragmaticworks.com/Products/Business-Intelligence/BIDocumenter/Default.aspx SSIS Documentation with Object Lineage & Impact Analysis]

* [http://www.ssisdocumenter.com/ SSIS 2005/2008 Documenter]

* [http://sqlblog.com/blogs/andy_leonard/ SSIS 2005/2008 Design Patterns, Tips, and Tricks]

{{MS DevTools}}

{{data warehouse}}