Parameters in DTS tasks

#1

I am trying to put together a DTS task and am wondering
about parameters. Not sure if parameters will solve the
problem, but I'm trying to pull data from a table where
the date is the max date in the table. Can I set a
parameter to select max(date) from table? Then can I use
this param in my query for my DTS task? How do I refer
to the parameter in the query?

Thanks

#2

Thanks, that was an easy one. I should have known that,
but have been brain dead most of the day.

Quote:

-----Original Message-----
If you're looking to pull data from a table based on the
current maximum
date in that same table, then you don't need parameters
at all.

For example, here's a query to run against the Pubs
database.

select *
from sales
where
ord_date in (
select max(ord_date)
from sales
)

For your situation it may be faster to use a join
instead. Experiment and
decide.

Best regards.

JOH

"Andy" <drewb6911 (AT) yahoo (DOT) com> wrote in message
news:1edb01c37308$30b07870$a501280a (AT) phx (DOT) gbl...
I am trying to put together a DTS task and am wondering
about parameters. Not sure if parameters will solve
the
problem, but I'm trying to pull data from a table where
the date is the max date in the table. Can I set a
parameter to select max(date) from table? Then can I
use
this param in my query for my DTS task? How do I refer
to the parameter in the query?

Thanks

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Parameters in DTS tasks

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Parameters in DTS tasks - 09-04-2003 , 12:15 PM

Re: Parameters in DTS tasks - 09-04-2003 , 12:43 PM