November 6, 2009 at 7:18 am
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/
November 6, 2009 at 7:58 am
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.
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]
November 6, 2009 at 4:42 pm
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