19.3.09

Connecting to SQLite through SSIS

Moved here:

http://rainydaycode.wordpress.com/2013/05/27/connecting-to-sqlite-through-ssis/

5 comments:

Unknown said...

Great Article. I am currently trying to tackle the same issue. However, when I query the SQLite ODBC, it will not recognize any text fields...only Numeric. Ever encounter this problem?

Dave said...

I didn't notice any such issues. Text fields appeared to come back correctly.

It could be a version issue between the SQLite database and the ODBC driver? Or there are some options in the ODBC DSN Configuration that you might play with. I didn't change any of them for my database to work though.

Praneetha Reddy said...

Very very helpful.. I had been scratching my head over this and this fixed my issue... Thanx a ton...

Vijay said...

It was a very very useful post.. Thanks Dave... How do I contact you?

Unknown said...

Thanks for sharing this wonderful thing SQL Lite Database Integration Service