Alternative (or solution) to DTS Parameter ? -
09-06-2008
, 08:43 AM
Morning All,
I've got a DTS package that takes data from a Pervasive Database into
a SQL Database.
In the query I am using a WHERE clause that instead of your normal
"column name between variable x and variable y" I am doing a "variable
x between column name a and column name b"
When I subsitute the variable x with the parameter ?, I am getting an
error "Incompatible types in expression".
The parameter is set as a string...is there are different way to
"wrap" the ? so that Pervasive sees it as a string?
Thanks,
Steve |