Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How & where do you write to a Variable that has scope the entire Package? Expand / Collapse
Author
Message
Posted Friday, November 6, 2009 7:18 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 4,243, Visits: 4,291
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/

Post #814916
Posted Friday, November 6, 2009 7:58 AM


UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Yesterday @ 4:01 PM
Points: 1,471, Visits: 8,358

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

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.
Post #814938
Posted Friday, November 6, 2009 4:42 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:14 PM
Points: 4,243, Visits: 4,291
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/

Post #815257
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse