jeudi 24 septembre 2015

SSIS: ODBC Driver Manager The specified DSN contains an architecture mismatch between the Driver and Application

I created a data flow task in SSIS. On double clicking, that task I added up ado.net source and destination. Under ado.net destination, I selected connection manager as odbc, and selected a user dsn.

Now, before doing all this stuff, I installed odbc driver from ch-werner.de and created a user dsn. In that process, I selected sqlite3 driver and my database is with the extension .sqlite.

Now, that dsn is available at ado.net destination. But when I select table it shows me this error that "The specified DSN contains an architecture mismatch".

enter image description here

To fix this stuff up, I researched some of the links. One was like, creating a 32-Bit data source names by running c:\windows\sysWOW64\odbcad32.exe. But, when I am trying to create a new dsn through that, it's not having SQLITE3 driver under create new datasource.

enter image description here

Aucun commentaire:

Enregistrer un commentaire