Variables not generated in script task

Question

For some reason my variables which I have added to the readonlyvariables(also tried readwritevariables)are not generated in code when I want to use them in code. What am I missing? I've added this script task in the Control Flow. When adding it in a data flow, it works fine. Is this the problem?

Regards!

Hadi · Accepted Answer · 2019-07-25 21:56:37Z

2

Within a Script Task you have to use the following syntax:

Dts.Variables["varInputFile"].Value

Reference

Using Variables in the Script Task

answered Jul 25, 2019 at 21:56

Hadi

37.5k13 gold badges73 silver badges128 bronze badges

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

2 Comments

Miscode Over a year ago

Thnx, it did work. Do you know why they made this difference? One time you can use Variables. the other time you need to use your answer...

Hadi Over a year ago

@Miscode check the following article, you will find the difference in the comparison table: learn.microsoft.com/en-us/sql/integration-services/…

Collectives™ on Stack Overflow

Variables not generated in script task

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related