How to add rows using SSIS 2008 Script Component during transform?

Question

I have a SSIS 2008 script component which is setup as a transform (so it has an input and output), and what I want to do is take 1 row in an input and optionally output multiple rows.

In 2005 there was the AddRow and CreateNewOutputRows methods but those seem not to be available in 2008.

So how do I add rows during the transformation?

Todd McDermid · Accepted Answer · 2010-03-23 06:53:34Z

4

Your issue is likely that you have the component configured as a synchronous transform. If you do, you won't be able to add "extra" rows on the output.

If that's not the case, however, then all the facilities of 2005 are present in 2008. This includes the CreateNewOutputRows method, which I don't think you want in this case. It also includes the AddRow method - which will only be available on an output buffer, probably named Output0Buffer, which you won't see if your output is synchronous.

Review this to set up an asynchronous script.

answered Mar 23, 2010 at 6:53

Todd McDermid

1,69011 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to add rows using SSIS 2008 Script Component during transform?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related