My question is about DTS Data Driven Query. I read the docs, but I missed
When trying to get the Data Driven Query to work, I get through the
transformations page and when I get to the end, I get the error "the
Provider cannot derive parameter info and SetParameterInfo has not been
By way of additional info, I realize that in SQL Server the parameters are
but I am doing this using ODBC dsn (vfp with Other driver) and there we use
"?" to mark the parameters places.
Now, my question is this; Does ODBC expect to be inserting into my vfp
dbc into VIEWS (hence why it is asking for a view parameter) or into
TABLES, which is all that is in the target database?
Can anyone give me an example of what DTS is expecting in the pesky
parameter box and whether it presumes views instead of tables on the target?
Andrew Georgopulos; MCSD