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?