Learn how to use SQL to import and export data between different formats and platforms, such as CSV, Excel, and different databases.

Now that you’ve automated the fetching of your flat file via FTP, the next step is to automatically import that file into SQL Server. To do this, we’ll use an SQL Server Agent Job.

Prepare to Bulk Import Data (SQL Server) [!INCLUDE SQL Server] You can use the bcp command, BULK INSERT statement, or OPENROWSET (BULK) function to bulk import data from a data file only.

Samples on how to import data (JSON, CSV, Flat-Files, etc) into Azure SQL All samples are in the script folder. Sample data used for running the samples is in json and csv folder.