Forum Discussion

HarRuc's avatar
HarRuc
Regular Visitor
10 years ago

importing data from csv to sql data warehouse

I have 100s of heavy CSV files and wanted to upload it on Sql Data WareHouse, and then connect it with PowerBI. Whats the best way to do so?   I have referred to this page which talks about using b...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
10 years ago

Hi HarRuc,

 

Based on my research, you can use SSIS package to import CSV files to SQL database, then import data from SQL Server to SQL Data Warehouse. For more information, please take a look at below links:

 

Importing data from CSV To SQL using SSIS ScriptTask

Load data from SQL Server into Azure SQL Data Warehouse (SSIS)

 

As the issue is more related to Azure SQL Data Warehouse, I would suggest you create a thread in Azure SQL Data Warehouse forum to get dedicated support.

 

Best Regards,
Qiuyun Yu