Has anyone successfully imported data from pervasive over the .net managed odbc bridge? Our admin has set up a odbc connection that works through Excel, but in SSIS the connection manager errors when trying to connect at runtime (the "test connection" button in the connection wizard reports that everything is ok though).
What error are you getting?|||"Data source name not found and no default driver specified"
|||A bit more info on this:
The connection seems to work in design time as metadata is fetched from the datasource to populate the column mappings in the datareader source|||
For anyone interested:
This was an issue with running the ODBC driver (presumably 32 bits) in 64bit mode. Running the package in 32 bit mode fixed the problem.
No comments:
Post a Comment