"John Brian" <JohnBrian77@hotmail.com> wrote in message
news:%23Q6g%23TK6EHA.2592@TK2MSFTNGP09.phx.gbl...
> 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
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:#BSOsyL6EHA.2568@TK2MSFTNGP11.phx.gbl...
> 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@hotmail.com> wrote in message
> news:%23Q6g%23TK6EHA.2592@TK2MSFTNGP09.phx.gbl...
> > 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
> >
> >
>
>