DTS Task - Input Parameter Problem

[gmctrek]

I have a DTS package with a 'Transform Data Task' that copies data from Sybase to MS SQL.

I use an SQL statement that has global variables (?) for the date range.

Select *
from table
where date >= ? and date <= ?

(parameter 1 is begin date and parameter 2 is end date)

I get an error message when I click on the parameter button to assign the each parameter. This is the error message:

Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description: Provider cannot derive parameter information and SetParameterInfo has not been called.

HELP
Gmctrek

 

[gmctrek]

I found the answer. Sybase cannot be parameterized. I will have to build a stored procedure and pass the parameters.

gmctrek