How can use read and write variable in ssis script component?

Question

I'm new in ssis and want to pass read and write variable to the script component,for that purpose, define variable in script editor windows:

and in the script write this code for use that:

but when run that data flow,i get this error:

How can i solve that problem?search on the web i did not understand anything.thanks all.

Community · Accepted Answer · 2017-05-23 10:33:45Z

1

That means that you can use variables from ReadWriteVariables only at PostExecute method, for example, to save your counter value. If you need to read this variable before PostExecute method, you can specify it as ReadOnlyVariables. Caveat - you can choose only one of the collections, not both. This is by Microsoft design.
If you need to have read access to a read-write variable earlier that PostExecute, you can call VariableDispenser as described here. But in this case you have to exclude this variable from both ReadOnlyVariables and ReadWriteVariables lists.

edited May 23, 2017 at 10:33

CommunityBot

11 silver badge

answered Aug 29, 2016 at 12:55

Ferdipux

5,2791 gold badge22 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

How can use read and write variable in ssis script component?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related