如何使用Azure将数据加载到SQL Sink? [英] How to load data into sql sink using azure?

问题描述

我正在尝试使用azure数据流将数据加载到Azure SQL数据库中.但是由于某种原因，我无法连接到我的接收器数据库.我已经尝试了一切，但是没有运气.创建数据集时，我可以连接到SQL数据库，但是为什么在使用数据集作为接收器时却无法连接到数据库.

I am trying to load data into the Azure SQL database using azure data flow. But for some reason, I cannot connect to my sink database. I have tried everything, but no luck. I am able to connect to the SQL database when I create a dataset, but why can't I connect to the database while using the dataset as my sink.

请在下面找到我的流程的摘要:

Please find the snippet of my flow below:

但是当我想使用该数据集将数据加载到数据流中时，它给了我以下错误.我想将数据加载到SQL中的原因是我要删除行和CSV，而其他数据集将不允许我这样做.

But when I want to use this dataset to load the data in the data flow, it is giving me the following error. The reason I want to load the data into SQL is that I want to delete rows and CSV and other datasets won't let me do this.

如果有人可以帮助我，我将非常感激.

I would really appreciate it if anyone can help me with this.

推荐答案

打开您的允许Azure服务和资源访问此服务器选项，并在Azure SQL数据库的防火墙设置中添加客户端IP.

Open your Allow Azure services and resources to access this server option and add your Client IP at the firewall settings of Azure SQL database.

请按照以下步骤操作:

这篇关于如何使用Azure将数据加载到SQL Sink?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！