Saturday, June 25, 2011

How to redirect rows based on condition in script component of an SSIS package .

1) In the script component,check the Buffer Wrapper where there is a class for Input0Buffer. Two functions can be appended to the class like the below :


2) The numbers in the brackets of Direct Row represent the output column numbers as they can be observed in the Advanced properties of the script component.


3) These functions can be called from the main class based on the conditions and rows get
redirected based on the conditions.




4) I was able to achieve this successfully. Hope this is clear and if any clarifications are required I am on twitter.



No comments:

Post a Comment