Hi,
Does anyone know if the VisualFoxPro 9.0 OLEDB driver supports parameters Trying to pass parameterised queries from SSIS results in the error reported below, which implies it does support parameters, but that SSIS is not calling the driver properly somehow.
Regards,
Richard
-----------------------------------------------
Error MsgBox:
TITLE: Microsoft Visual Studio
------------------------------
Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.
------------------------------
ADDITIONAL INFORMATION:
Provider cannot derive parameter information and SetParameterInfo has not been called. (Microsoft OLE DB Provider for Visual FoxPro)

FoxPro OLEDB Driver - pass parameters
nickc
This conversation is taking place on the newsgroup "microsoft.public.fox.vfp.dbc", thread "Passing parameterised SQL statements to FoxPro OLEDB"
There is nothing wrong with the FoxPro driver, you can pass parameters OK from a native VB project
So it looks at the moment like this may be a BUG in SSIS.
Comments
Will keep you posted,
Rich