How to load data into sql sink using azure?

Question

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:

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.

Do you 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? — Steve Johnson
– Steve Johnson, Commented May 28, 2020 at 7:49
Thank you so much. Yes, I finally got it now. You are right, that was the problem. :) — user86907
– user86907, Commented May 28, 2020 at 7:58
Your are welcome. I post it as answer,please mark it.Thanks a lot. — Steve Johnson
– Steve Johnson, Commented May 28, 2020 at 8:36

Steve Johnson · Accepted Answer · 2020-05-28 08:29:30Z

2

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.

Please follow this:

answered May 28, 2020 at 8:29

Steve Johnson

8,8081 gold badge11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to load data into sql sink using azure?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related