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".
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.
Aucun commentaire:
Enregistrer un commentaire