How & where do you write to a Variable that has scope the entire Package?

Question

How & where do you write to a Variable that has scope the entire Package?

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

Should be able to create a variable that has a scope of the whole package making sure that when you create the variable no task or container is selected.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 2

I need to write to variables that has a scope of the entire package.

If you include the task in a container object then the variables are within the scope of the container.

I made some progress.

The Variable that contains the path & file name did not show anything when I previewed prior to including the task in the container object.

Prior to this change the variable that contained the path & file name when I selected evaluate expression did not display anything.

Now It only shows the Path which is a hard coded variable. It does not show the file prefix, datetimestamp & file prefix, so it bombs out.

I wish that I knew how to write to a package (comporable to a DTS Global Variable).

Thank you,

Kent

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/