What are the easiest options to import a csv file into SQL azure? 

I need to automate the process.

I am fluent with coding, but I expect that this particular task can be done without custom coding, or minimal PowerShell scripts.

Thank you

• Edited by amx2012 Wednesday, September 09, 2015 7:30 PM

BCP is the recommended tool to copy CSV data to Azure SQL DB : https://msdn.microsoft.com/en-us/library/ms162802(v=sql.130).aspx

If you want this to be an ongoing ETL capability, Azure Data Factory is a fully managed service that supports upload of files from on premises to Azure SQL Database at scale : https://azure.microsoft.com/en-us/documentation/articles/data-factory-data-movement-activities/

Check the thread below for details :

https://social.msdn.microsoft.com/Forums/azure/en-US/ec0cd0ec-da35-41ea-afaa-24aacd7fee70/uploading-csv-file-into-azure-sql-database?forum=ssdsgetstarted#27bff82b-7ca6-4a00-85a3-70dbd0e717a1

• Proposed as answer by Casey KarstMicrosoft employee, Moderator 8 hours 5 minutes ago

BCP is the recommended tool to copy CSV data to Azure SQL DB : https://msdn.microsoft.com/en-us/library/ms162802(v=sql.130).aspx

If you want this to be an ongoing ETL capability, Azure Data Factory is a fully managed service that supports upload of files from on premises to Azure SQL Database at scale : https://azure.microsoft.com/en-us/documentation/articles/data-factory-data-movement-activities/

Check the thread below for details :

https://social.msdn.microsoft.com/Forums/azure/en-US/ec0cd0ec-da35-41ea-afaa-24aacd7fee70/uploading-csv-file-into-azure-sql-database?forum=ssdsgetstarted#27bff82b-7ca6-4a00-85a3-70dbd0e717a1

• Proposed as answer by Casey KarstMicrosoft employee, Moderator 8 hours 14 minutes ago

Before we consider BCP as an answer, lets cover its licencing here.

Does BCP comes with Azure SQL tools or client? Does it included with  Azure SQL licence?

Thank you,