Does anyone know how can I use DTS global variables in DTS SQL statement?
Thanks a lot.

Do you mean like this

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

or

How to Use Lookups in DTS
(http://www.sqldts.com/default.aspx?277)

(Towards the end of the second article)

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"francis" <francis (AT) microsoft (DOT) com> wrote