How to load csv file to MS SQL Database via data factory

Question

How to load csv file to MS SQL Database via data factory

Mahesh Madhusanka 221

Hi Team,

Currently we have some csv files(database tables) on the Data lake and we need to load that relevant csv file (SQL tables) to MS SQL table, So what are the option on that and Appreciate if you could guide on that?

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2020-08-12T04:17:03.707+00:00

Hello @Mahesh Madhusanka ,
Following up to see if the below suggestion provided by @Vaibhav Chaudhari was helpful. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2020-08-17T10:13:53.067+00:00

Hello @Mahesh Madhusanka ,
Just checking in to see if the below answer helped. If this answers your query, do click “Accept Answer” and Up-Vote for the same. And, if you have any further query do let us know.

3 answers

Your answer

PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2020-08-12T04:17:03.707+00:00

Hello @Mahesh Madhusanka ,
Following up to see if the below suggestion provided by @Vaibhav Chaudhari was helpful. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 90,641 Reputation points Moderator

2020-08-17T10:13:53.067+00:00

Hello @Mahesh Madhusanka ,
Just checking in to see if the below answer helped. If this answers your query, do click “Accept Answer” and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

Vaibhav Chaudhari 38,916 Volunteer Moderator

Use data factory to load CSV to SQL. Reference - quickstart-create-data-factory-copy-data-tool

Try using External table that points to the csv file and later load data from external to final table. Reference - create-external-table-transact-sql

Give it a try and revert

===============================================

If the response helped, do "Accept Answer" and upvote it -- Vaibhav

Answer 2

Mahesh Madhusanka 106

HI @Vaibhav Chaudhari

Thank you very much for your comment and Answer its helpful, i don't have a option select accept answer.

Thank
Mahesh

Vaibhav Chaudhari 38,916 Reputation points Volunteer Moderator

2020-08-19T14:44:52.523+00:00

You should see "Accept" button like below, that is used to accept the answer

Answer 3

Mahesh Madhusanka 106

HI @Vaibhav Chaudhari yesbut on the my screen there not have that button today.

Vaibhav Chaudhari 38,916 Reputation points Volunteer Moderator

2020-08-19T19:18:28.787+00:00

I think you posted a question from your old profile and not using a new profile. If you login with old profile from which you posted a question, you should see "Accept" button.

Share via

How to load csv file to MS SQL Database via data factory

3 answers

Your answer