SQL Server Integration Services: Difference between revisions

Revision as of 17:42, 22 March 2013

Revision as of 17:46, 22 March 2013

Line 22:

===Features of the data flow task===

SSIS provides the following built-in transformations:<ref>{{cite web|title=Integration Services TrnansformationsTransformations|url=http://msdn.microsoft.com/en-us/library/ms141713.aspx}}</ref>

* Conditional Split

Line 30:

* Fuzzy Grouping

* Lookup and [[Fuzzy logic|Fuzzy]] Lookup

* Percentage Sampling<ref>[{{cite web|url=http://msdn.microsoft.com/en-us/library/ms139864.aspx|title=Percentage creates a sample data set by selecting a percentage of the transformationSampling input]Transformation}}</ref> and Row Sampling Transformation.

* Copy/Map, Data Conversion, and Derived Column

* Aggregation

* Data Mining Model Training, Data Mining Query, Partition Processing, and Dimension Processing

* [[Pivot table|Pivot]] and Unpivot

* [[Slowly Changing Dimension]]

* Script Component

* Audit

* Cache Transform<ref>[{{cite web|url=http://msdn.microsoft.com/en-us/library/bb895264 writes data from a connected data source in the data flow to a |title=Cache connection manager]Transform}}</ref>

* Export and Import Column

* OLE DB Command

Line 47:

The Conditional Split transformation is conditionally route rows to other transformation objcts a particular condition. It is similar to the "if..else" construct in the C language.

<!--this is not good for etl------>

==Other included tools==