SQL Server Integration Services: Difference between revisions

Revision as of 17:46, 22 March 2013

Revision as of 17:50, 22 March 2013

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 Sampling Transformation|work=Microsoft Developer Network |publisher=Microsoft |accessdate=22 March 2013}}}}</ref> and Row Sampling Transformation.

* Copy/Map, Data Conversion, and Derived Column

* Aggregation

Line 38:

* Script Component

* Audit

* Cache Transform<ref>{{cite web|url=http://msdn.microsoft.com/en-us/library/bb895264|title=Cache Transform|work=Microsoft Developer Network |publisher=Microsoft |accessdate=22 March 2013}}}}</ref>

* Export and Import Column

* OLE DB Command

Line 46:

* Row Sampling

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

==Other included tools==