需要从azure blob导入文件到azure sql [英] Need to import a file as it is from azure blob to azure sql

问题描述

您好，

我需要从在azure blob中托管的CSV插入记录到azure sql.我需要通过使用批量插入的SP来实现这一目标.

I need to insert records from a CSV which is hosted in azure blob to a azure sql. I need to achieve this through a SP using a bulk insert. 

如果您有任何代码/实施步骤，请帮助我.

Please help me if you have any code/ implementation steps. 

谢谢

Vikram 

Vikram 

推荐答案

hi Vikram，

hi Vikram,

ADF复制活动可以支持从Azure Blob Csv复制到Azure Sql(将使用批量插入)，这仅需要从UI创建复制活动，而无需实现任何代码. (请参阅https://docs.microsoft.com/zh-cn/azure/data-factory/supported-file-formats-and-compression-codecs#text-format )

ADF Copy Activity can support copy from Azure Blob Csv to Azure Sql (which will use bulk insert), which just need to create a Copy Activity from UI and doesn't need to implement any code. (please see https://docs.microsoft.com/en-us/azure/data-factory/supported-file-formats-and-compression-codecs#text-format )

如果不能满足您的要求，请告诉我.

Please let me know if it can't satisfy your requirement.

此致

Gary

这篇关于需要从azure blob导入文件到azure sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！