1.

Differences Between Script Task & Script Component And Its Advantages?

Answer»

SCRIPT task is control flow level item where as script component is data flow level item, both of the functionalities 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.

Script task is control flow level item where as script component is data flow level item, both of the functionalities 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.


Discussion

No Comment Found

Related InterviewSolutions