I am creating a simple data flow Job, were my Source is a flat file and Target is an Access Database. I have created Format for Flat file and have created a datastore for Access using ODBC. When I am executing the job, it is giving me an error
SQL submitted to ODBC data source resulted in error <[Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented >
I am not sure why this Error is , I have installed MDAC 2.8 on the PC but still the same error. Please if any one can help.
i think that BODI uses some Not-Supported-Functions or an unsupported Codepage?
To find this bad Function, i would do some traces.
First the normal ODBC Trace. Could be activated and deactivated inside the ODBC-Adminpanel. Look for the message “Optional feature not implemented”. Try to change your Connection-Settings or your transformations.
Second the BODI Trace. Look for the insert statement and functions that Access could not understand. Try this insert statement inside the Access-Query. If Access brings the same error, change your query that Access could understand it.
If this brings no result, i would call the BO-Support.