PostExecute not firing in SSIS script component

Question

I have a Source Script Component in SQL2012. I believe if you want to set a Read/write variable in the Scriptcomponent it must be set in the Postexecute method . And I have done so like this;

    public override void PostExecute()
{
    base.PostExecute();
    Variables.value1 = "some value";
}

I tested the variable after the script component ran and found it hadn't been set. I set a break point in the PostExecute method and confirmed it never gets called.

I even wrote a very simple new package and tested it again with the same results. Can anyone tell me why the PostExecute will not fire.

I'm not aware of any restrictions on seting a variable here (regardless of if there are records to process or not).

Joost · Accepted Answer · 2015-11-10 07:19:24Z

0

The variable can be set in the script component, but you can only use it after the Data Flow task is finished (in the next task).

answered Nov 10, 2015 at 7:19

Joost

1,9313 gold badges20 silver badges22 bronze badges

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

1 Comment

ErickTreetops Over a year ago

How does that prevent the event from firing ?

ErickTreetops · Accepted Answer · 2015-11-17 05:12:20Z

0

After some testig it appears that when you use a script component as a "Source" the PostExecture event never fires. Works fine a "Transformation". Didn't test out "Destination" type. Nothing in the Microsoft documentation mentions this fact so it's missleading.

I ended up using the rowcount control to count records. Not sure what I would have done if i had needed to to more on the PostExecture event.

answered Nov 17, 2015 at 5:12

ErickTreetops

3,4054 gold badges29 silver badges39 bronze badges

Comments

Plater1 · Accepted Answer · 2019-12-03 19:02:44Z

0

I have used a Script Component as a source many times and PostExecute does fire.

answered Dec 3, 2019 at 19:02

Plater1

1

2 Comments

Badro Niaimi Over a year ago

You may need to give some details!

Yunnosch Over a year ago

This seems to be a "cannot reproduce" comment. It surely does not solve OPs problem. For this kind of (in itself not inappropriate) comment, please use a comment, not an answer. meta.stackexchange.com/questions/214173/…

Collectives™ on Stack Overflow

PostExecute not firing in SSIS script component

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related