Many times, you may want to import data from SQLite into SQL Server since SQLite has limited functionalities. In this case, SQLite OLE DB Provider can be used so that it will save you a lot of valuable time. The following sections will show you how to use SQLite OLE DB Provider with DTS to import SQLite data into SQL Server databases and discuss some of the limitations as well.

Like Using MySQL OLE DB Provider with DTS, using SQLite OLE DB Provider with DTS is very similiar. They are also 10 steps of which most are the same. Please refer to Using MySQL OLE DB Provider with DTS. Only sep 1 and step 2 are slightly different.

At step 1, you shall select SQLite Provider instead of MySQL Provider

At step 2, you only need to fill in the data source with the SQLite database file name. 

The data type mapping above gives us a guideline on how do we map data columns between SQLite and SQL Server. The current limitations are as follows:

• Column size cannot be more than 3999
• Columns with TEXT and BLOB data types cannot be transfered. we are actively investigating this issue.