How to populate a global variable by reading the data from a database.
Basically I want to find out the max date from a field and poulate the
variable.
SQL2K.
Thanks
Brian

Use an ExecuteSQL task

Statement would be

SELECT MAX(whatever) as MaxValue FROM Table

Hit the Parameters button | Output Parameters | Row Value

In the grid at the bottom you can then map MaxValue to a Global Variable


--



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


"John Brian" <JohnBrian77 (AT) hotmail (DOT) com> wrote

Thanks.
It helped.
John


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote