Script task is control flow level item where as script component is data flow level item, both of the functionality are same.
This 2 are very powerful items in SSIS.
Normally we can implement custom code by using these components.
By using this two items we can perform any action like DML operations on the data from DB, file and we can do any operation using c# or vb.net code we can use it as Source, destination as well. In single sentence i can conclude the usage of this items we can use to perform any ETL operation if you are good at .net.


Leave a Reply

Your email address will not be published. Required fields are marked *

Name *
Email *
Website