Hello all,
How, from a SQL Task, can I assign the value to a global variable.
I mean, in a SQL Task I execute a SQL that returns a date value, I need to
assign this value to a global variable.
I've tried this:
select gv = mydate from my table. Here gv does not have value!!
or
select @gv = mydate from mytable. This generates a error because @gv is
not declared

So how is the correct form???
Thanks

Are you using SQL Server 2000 or 7

2000 - Look for a parameters button
7 - Good way is to either

1. Use an Active Script task and an ADO recordset
2. Use a datapump and pump the record into the GV


--

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