Hi there

Is it possible to reference global variables in an 'execute SQL task' in
SQL Server 7? I know you can use parameters in SQL 2000, but is there
another way round this in SQL 7?

Thanks a lot

Lewis Veale
lewisdotvealeatpdms.com
www.pdms.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You would have to do this in a Active Script task prior to the ExecuteSQL
task

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

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Lewis" <lewisdotvealeatpdms.com> wrote

Thanks Allan. I thought that might be the case, but wanted to be sure.

Lewis Veale
lewisdotvealeatpdms.com
www.pdms.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!