Problems with Input Parameters - 11-01-2004 , 06:28 AM
I'm trying to pass an input parameter into an Execute SQL task in a DTS
The task is running against an Ingres database using an ODBC connection.
The SQL is:
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?