SQL Server Integration Services: Difference between revisions

Revision as of 16:09, 21 March 2013

Revision as of 17:42, 22 March 2013

Line 22:

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

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

* Conditional Split

Line 43:

* Row Count

* [[term extraction|Term Extraction]]

* Term Lookup/

* Row Sampling

The Conditional Split transformation is usedconditionally toroute speedrows upto theother querytransformation on the source table based onobjcts a particular condition. It is similar to the "if..else" construct in the C language.

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