Here’s how to connect to SQLite via SSIS
- Go to http://www.ch-werner.de/sqliteodbc/. Download the current version of sqliteodbc.exe
- Run this program, and it will install the ODBC drivers for SQLite on your computer
- Open Administration tools, then Data sources (ODBC)
- In the User DSN tab, click on Add…
- Select the SQLite3 ODBC driver and click on Finish
- On the next page, type a name for the data source, and obtain the database file using the Browse button.
- Switch to SSIS and create a new data stream
- In the data stream, right-click on Connection managers and create a new ADO.Net connection
- Click on Create to create a new data connection
- Select .Net Providers / Odbc Data Provider from the Provider drop-down list
- Select the ODBC connection created earlier and Test the connection
- You can then add an ADO NET source, connect to this connection and load data from a table.
