Aug 30, 2010
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:
Name,Rohit Age,28 Sex,Male Name,Mohit Age,20 Sex,Male Name,Ram Age,28 Sex,Male Name,Shyam Age,20 Sex,Male
Rohit 28 Male
Mohit 20 Male
Ram 28 Male
Shyam 20 Male
Aug 16, 2010
At times I have seen in SSIS forums people ask about the way they can know the number of records updated by a query or deleted by a query in an Execute SQL Task in control flow. Even I replied at times that its not possible(in a direct manner), until I read about the property ExecValueVariable.
Read more here.