This is an old debate and yet not resolved. To use Script Component or Derived Column Transformation??
Yes Derived Column Transformation can NOT do all that can be done in Script Component.
Advantages of Script Component:
Advantages of Derived Column Transform:
Drawbacks of Script Component:
Drawbacks of Derived Column transform:
So I conclude that Script Component should be used when the logic is complex and Derived component should be used when me need some minor modification like append or nesting of if then else loop up to 3(that’s what I feel not a rule as such) levels, or simple string manipulation .
As per the performance issue regarding the use of the above I will do some tests and keep this post updated.
Would like to hear your views as well…
Tags: SSIS, Script Component, SQL Server, Derived Column, MSBI, #BI, #SQLSERVER, BRH,