SQL Server Integration Services: Difference between revisions

Content deleted Content added
m cite tag cleanups
m fix more typos
Line 22:
 
===Features of the data flow task===
SSIS provides the following built-in transformations:<ref>{{cite web|title=Integration Services Transformations|url=http://msdn.microsoft.com/en-us/library/ms141713.aspx|work=Microsoft Developer Network |publisher=Microsoft |accessdate=22 March 2013}}}}</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 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