I need to import data from sqlite into SQL Server so we can include it in our data warehouse.

Based on previous system volume. Id expect there to be 50-100,000 rows after a couple of years. For simplicity id truncate the target table and reimport the data each day

Dbs exist on different Servers. Both servers are win 2012. SQL Server 2012 SP1.

Ideally id like to import directly from the source sqlite db into SQL Server. We use SSIS as our standard ETL tool elsewhere and so for consistency id like to use that if possible.

Id appreciate suggestions for a simple, robust & reliable approach. How can SQL connect? ODBC?

Im also interested in practical alternatives. Plan B: CSV/BCP?

  • Once, or automated? – CL. Nov 16 '15 at 12:24
  • The aim would be to import daily. – Sir Swears-a-lot Nov 16 '15 at 18:27
  • 1
    You can use ODBC, as well as You can connect SQLite as linked Server to the SQL Server. SSIS (or any other ETL) - more flexible, linked sever - mostly direct way. – a_vlad Nov 16 '15 at 18:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.