Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

SSIS scenarios...
Browse by Tags · View All
MSBI 30
SSIS 27
BRH 15
SQL Server 15
#BI 14
Script Component 9
#SQLSERVER 8
#SQL Server 7
Flat File Source 5
Script Component Source 5

Archive · View All
August 2010 4
March 2011 3
September 2010 3
February 2013 2
June 2011 2
November 2010 2
May 2010 2
November 2009 2
March 2010 2
May 2012 1

To use Script Component or Derived Column Transformation?? Is the question..

Aug 30 2010 4:01PM by Sudeep Raj   

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:

  • Code is more readable
  • Easy to maintain and debug.
  • Can achieve a lot more than what can be done in Derived Column Task.

Advantages of Derived Column Transform:

  • Easy to code for the first time.
  • Very useful if you have good command over Expressions
  • No need to get into the complexities of writing Script Component.

Drawbacks of Script Component:

  • Not very user friendly Interface
  • A Bit confusing at times
  • One needs to learn C# or VB.NET coding (That’s a separate debate whether SSIS Developers should know .NET or that, will not get into that right now.)

Drawbacks of Derived Column transform:

  • VERY DIFFICULT TO DEBUG complex expressions.
  • Difficult to code if the level of nesting goes beyond 3 or may be 5(that’s what I feel not a rule as such).

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,


Sudeep Raj
12 · 13% · 4306
1
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"To use Script Component or Derived Column Transformation?? Is the question.." rated 5 out of 5 by 1 readers
To use Script Component or Derived Column Transformation?? Is the question.. , 5.0 out of 5 based on 1 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]