SSIS Script Component runtime error -


i got valid issue when run package. runs failed in pc , success in else. error caused script component (turned red), , in post execute phase, not post execute in script componet, in runtime of package. error is:

information: 0x40043008 @ data flow task, ssis.pipeline: post execute phase beginning. error: 0xc0047062 @ data flow task, script component [263]: system.invalidcastexception: unable cast com object of type 'system.__comobject' interface type 'microsoft.sqlserver.dts.runtime.wrapper.idtsvariables100'. operation failed because queryinterface call on com component interface iid '{22992c1d-393d-48fb-9a9f-4e4c62441cca}' failed due following error: application called interface marshalled different thread. (exception hresult: 0x8001010e (rpc_e_wrong_thread)). 

enter image description here

i guess issue related variables, because when remove code related variables, package run successfully. code in script component:

private int scheduled550; private int scheduled620; private int scheduled720; private int scheduled820; public override void preexecute() {      base.preexecute();     scheduled550 = variables.count550;     scheduled620 = variables.count620;     scheduled720 = variables.count720;     scheduled820 = variables.count820;  }  public override void postexecute() {     base.postexecute();  } 

did ever encounter same issue? can tell me post execute phase do? thanks

more info: have tried re-install sql server, not help. , not script component variables failed running in ssis (not in same package error one)

all tasks/containers in ssis have same lifecycle. can see of watching event handlers fire. in script component, inside data flow task, going under go various steps. part of validation (this contract says should have column table integer type- can connect, exist, right type, etc).

after validation, tasks have setup , tear down steps perform. since appear working ssis variables in script, part of pre/post execute time spent allowing translation of variable (ssis) variable (.net) , again.

until see specific code in postexecute method causing failure, can't state code issue might have been.

i cannot recreate issue. while 2012 release of integration services, script component using behave same. did not send output excel should not matter given it's script failing.

data flow task

my script component. have selected variable, user::count550 readonly variable in menu before editing code.

public class scriptmain : usercomponent {     private int scheduled550;      public override void preexecute()     {         base.preexecute();         this.scheduled550 = variables.count550;     }      public override void postexecute()     {         base.postexecute();         //this.variables.count550 = scheduled550;         //this.variabledispenser.lockforwrite("count550");     }      public override void input0_processinputrow(input0buffer row)     {         if (true)         {             this.scheduled550++;         }     }  } 

Comments

Popular posts from this blog

php - Calling a template part from a post -

Firefox SVG shape not printing when it has stroke -

How to mention the localhost in android -