Hello, I am trying to map a package level variable to a SQL command that is
in a Data Flow Component.

I used the same set up as describled it this...

http://msdn2.microsoft.com/en-us/library/ms139904

My souce DB is a DBase IV file (.dbf). I have a working connection to it.

This is the syntax of the query:

SELECT * FROM class1 WHERE (dt_lsttrns >= ?)

Here is my error.


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)







I am not sure why this won't work....but kinda a bummer....any help would be
great!!

Thanks!

Eric