I believe a global is available till package completion.



Christopher Bellizzi
SQL DBA/Systems Analyst
240 Fall Street
SFO Main Office
Seneca Falls, NY 13148
315-568-7886


-----Original Message-----
From: Joseph Malek
[mailto:mssqldba-ezmlmshield-x82421621.[Email address protected]
Sent: Wednesday, May 30, 2007 3:13 PM
To: LazyDBA Discussion
Subject: GlobalParameters

Are global paramaters consumed/destroyed when they are used? i.e. if I
refer to them using a Dynamics Property Task in DTS can I refer to them
later down in the transformation? Say step 2 then again is step 4?

Thanks!

Joseph



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



*****************************************************************
This e-mail and any files transmitted with it may be proprietary
and are intended solely for the use of the individual or entity to
whom they are addressed. If you have received this e-mail in
error please notify the sender. Please note that any views or
opinions presented in this e-mail are solely those of the author
and do not necessarily represent those of ITT Corporation. The
recipient should check this e-mail and any attachments for the
presence of viruses. ITT accepts no liability for any damage
caused by any virus transmitted by this e-mail.
*******************************************************************


MS Sql Server LazyDBA home page