CODEWITHSUNDEEP
ssisbids
asd
asd

Reputation: 3

How to access variables in ScriptComponent in a DataFlow task

I am trying to access the package level variable "FirstRecord". However, I can't do : 

dts.variables("FirstRecord").value = Truth

How do I access variables in a DataFlow Script Component?

Upvotes: 0

Views: 5294

Answers (1)

bobs
bobs

Reputation: 22194

The syntax is different in a Script Component in a Data Flow Task than it is in a Script Task. You are using the syntax for the Script Task.

You can try this to assign a value to the package variable from a Script Component

Variables.FirstRecord = Truth

You can only assign values to a package variable in the PreExecute or PostExecute procedures.

Upvotes: 4

Related Questions