Using SSIS :What is better between using REST API or querying a database directly?

Question

I am working on creating a data warehouse for a client. To extract data, I can use :

• Direct T-SQL queries to the production database
• API/JSON
  

I want to know what is better concerning the data quality and performance between these two alternatives ?

Answer 1

If you are importing data from a SQL Server instance to another SQL Server instance (DWH) and you have the possibility to use SSIS, go with T-SQL or direct bulk operations you can find as components in the VS toolbox. SQL Server Source and SQL Server Destination should meet your requirements.