SQL Server Integration Services: Difference between revisions

Content deleted Content added
done!
Line 25:
 
Various transforms exist in the product, including a sort, aggregation, and lookup. A derived column transform evaluates an expression to compute the value for a new column. A script transform is available which allows more complicated transform to be written in [[VBScript]].
 
Unlike DTS, SSIS can have more than one transform in its operation. Transforms, data sources, and data destinations can have multiple inputs and outputs. Most have error outputs so that rows which would cause the transform to fail can be optionally redirected for further or alternate proessing.
 
Any number of sources or destinations are supported in a data flow.
 
==Extensibility and Programabiltiy==