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

  • I can create a Global (Package Variable) but how do I write to it using a Script Task or Expressions that have a Global (Package Scope).

    My problem is that I a Flat File Connection and I use an expression to create the Connection Name using Variables but I can't reference that Connection Name in the next task Send Mail when I attempt to send the file using an expression.

    I need to be able find out how to write to a Package Variable.

    I have no issues creating variables that are scope is local (limited) to the specific task.

    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/

  • 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]

  • 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/

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

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