Hi all.

I'm trying to pass an input parameter into an Execute SQL task in a DTS
package.

The task is running against an Ingres database using an ODBC connection.

The SQL is:

update temp_table
set periodstartdate = ?

If I click on the "Parameters" button, DTS tells me "The SQL statement does
not contain any parameters". (If I try to run the query in the Query Builder
screen, it tells me "Provider cannot derive parameter information and
SetParameterInfo has not been called" - as you would expect).

Does anyone know how I might convince DTS that there genuinely is a paramter
in my query, and that I would quite like to map to it?

Many thanks

Paul