DTS Parameter on Execute SQL Task

First I am trying to use DTS for purging data. The first thing I want to do
is export the data to be purged to a csv file. I am using parameters to hold
variables such as dates.

The export routines work using transform data task using the following query:

select sub.* from proddta.f3102 as sub
join proddta.f4801 as main on sub.igdoco=main.wadoco
where main.watrdj<?

the parameter is named FIRSTOFLASTYEAR as an unsigned int 4 with a value of
104001 (our software uses integers to represent dates)

The next step I am trying to do is to use an execute sql task to delete the
affected data. The query is below:

delete sub from proddta.f3102 as sub
join proddta.f4801 as main on sub.igdoco=main.wadoco
where main.watrdj<?

When trying to assign the parameter I get an error saying "invalid object
name sub". It also won't parse the sql. However, if I replace the ? with
the 104001 then everything parses correctly.

What am I doing wrong?

Thanks in advance

Chris

this is probably a bug of sql parser. i remember old threads about this
issue.
first write a simple query , map parameters , then change your query. it
would work ,even when you get this error.
another solution would be creating the sql query in an activex script task
, then setting the query of execute sql task..



"Chris" wrote in message

> First I am trying to use DTS for purging data. The first thing I want to
do
> is export the data to be purged to a csv file. I am using parameters to
hold
> variables such as dates.
>
> The export routines work using transform data task using the following
query:
>
> select sub.* from proddta.f3102 as sub
> join proddta.f4801 as main on sub.igdoco=main.wadoco
> where main.watrdj<?
>
> the parameter is named FIRSTOFLASTYEAR as an unsigned int 4 with a value
of
> 104001 (our software uses integers to represent dates)
>
> The next step I am trying to do is to use an execute sql task to delete
the
> affected data. The query is below:
>
> delete sub from proddta.f3102 as sub
> join proddta.f4801 as main on sub.igdoco=main.wadoco
> where main.watrdj<?
>
> When trying to assign the parameter I get an error saying "invalid object
> name sub". It also won't parse the sql. However, if I replace the ? with
> the 104001 then everything parses correctly.
>
> What am I doing wrong?
>
> Thanks in advance
>
> Chris