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.