What's the best way of populating the From and Thru date Global Variables for
a DTS to use as parameters in extract queries?

The short answer is "it depends".

I presume you have the query already and are just looking to get values in there?

You can use Disconnected Edit to populate the variables. You can also use DTSRUN and the /A switch

It is really about what is easiest for you

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Robert Hamilton" <RobertHamilton (AT) discussions (DOT) microsoft.com> wrote