SQL Server Integration Services: Difference between revisions

Revision as of 01:17, 18 February 2006

Revision as of 05:56, 21 February 2006

Line 33:

Any number of sources or destinations are supported in a data flow.

'''Transformations supported'''

SSIS provides the following built-in transformations:

* Conditional Split

* Multicast

* Union-All, Merge, and Merge Join

* Sort

* Fuzzy Grouping

* Lookup and Fuzzy Lookup

* Percentage Sampling and Row Sampling

* Copy/Map, Data Conversion, and Derived Column

* Aggregation

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

* Pivot and UnPivot

==Other included tools==