Script Component Types in SSIS .
We can use the script component to do data transformation from
source to destination.
Types of Script component:
There
are two types script components are available in SSIS.
ü
Synchronous Transformation script component
ü
Asynchronous Transformation script component
Synchronous Transformation
script component
In
Synchronous transformation, the input data/records will be processed one by
one.
Asynchronous Transformation
script component
In
Asynchronous transformation, all the input data will fetch all at the initial step
and it will process the record and produces the result.