I am creating a DTS package with a select query that
retrives information between Date1 and Date2.

Instead of changing the Dates in the underlying query, is
it possible to set the parameters when running a DTS
query ?

Thanks

You can use a parametrized query (select * from table where Date>?) and map
the parameters with a Global variable in the DTS package.

Francesco Anti

"Peter" <anonymous (AT) discussions (DOT) microsoft.com> ha scritto nel messaggio
news:13e101c57565$66661540$a601280a (AT) phx (DOT) gbl...