Not sure what you mean by SQL Script.
You can use Global Variables in your package referencing them all over.
What task do you want to use it in ?
Global Variables and SQL statements in DTS
http://www.sqldts.com/default.aspx?6,102,205,7,1
How to Use Lookups in DTS
http://www.sqldts.com/default.aspx?6,107,277,7,1
--
----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Joe M" <huy.nguyen (AT) mineman (DOT) com> wrote
Quote:
I currently have some global variables in DTS. How do I pass these Global
variables into a SQL script of the DTS package.
|
Global Variable to SQL script. -
07-21-2003
, 12:09 AM
Linear Mode
