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 ?

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@discussions.microsoft.com> ha scritto nel messaggio
news:13e101c57565$66661540$a601280a@phx.gbl...
[quoted text, click to view]