I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

You can access variables anywhere within a package. However, you still have
to specify whether you need read/write or just read access within a Script
task.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau


"rminder" <rminder (AT) discussions (DOT) microsoft.com> wrote

I am getting my feet wet in learning SSIS by taking over a somewhat complex
package. My question has to do with variables. In the Script Task Editor,
when I click on 'Script' on the left, on the right I see something called
ReadWriteVariables. When I enter variable names in this field, do I have
access to these variables anywhere in my package, or just the current
script?

Thanks very much - Randy

Randy:
You need to define the Variables before you can use them. And when you do,
pay particular attention to the Scope of the variables. One created in the
scope of a For Each loop will not be accessible to Tasks *outside* the loop.

Right click on the Control Flow and select Variables.
--
Todd C

"Tom Moreau" wrote: