I'm trying to query a FoxPro db (5.0) using SQL Server 2000 dts package.
My query has parameters set up in the where clause. I keep getting this
error:

Error Source : Microsoft OLE DB Provider for ODBC Drivers

Error Description : Provider cannot derive parameter information and
SetParameterInfo has not been called.

I've tried using both VFPODBC.DLL (6.0) & VfpOleDB.dll (8.0) as the data
source and neither one of them work. Will I not be able to use a
parameter in my query? If I can't, what else should I use?


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!