Creating MS Access datasource

I am trying to create a MS Access datasource to use it in a IS dataflow. I've done the following things:

1.I've created an ODBC datasource - System DSN, pointing to the Access database.

2.I've created an ODBC connection manager pointing to the ODBS datasource that I created in the previous step.

3.I've created a DataReader Source that uses as its Connection Manager the connection manager that I created in the previous step.

I get the following error message: "Cannot acquire a managed connection from the run-time connection manager." What can I do to solve this error?

Pedro Martins

The DataReader expects a managed connection. The ODBC connection manager returns a native object. The error message is literally correct.

Assuming that there is no particular requirement to use ODBC, I would use an ADO.NET connection manager with the Jet provider.

-Doug