CODEWITHSUNDEEP
azure-data-factory
Dhananjay Singh
Dhananjay Singh

Reputation: 11

Is there a way to load a .DAT file in the MS SQL Sever table using ADF?

I have a .DAT file in a ftp server. I have to load the data in a SQL table. I am trying to create datasets in ADF using this .DAT file using ftp as source and ADLS as sink. However it is not getting created. Please suggest how can this be done or if there are any alternatives

I tried loading the .DAT file to ADLS using file format as binary but I am unable to look at data.

If I use file format as csv then I cannot use comma, space, tab, blank space, etc. as delimiter and ADF requires me to enter a delimiter.

Upvotes: 1

Views: 371

Answers (1)

Pratik Lad
Pratik Lad

Reputation: 8382

I have taken simple .dat file with month data and tried to transfer it into SQL server table followed below procedure:

Dataset setting: enter image description here

Pipeline source settings: enter image description here

Successful pipeline run: enter image description here

I tried loading the .DAT file to ADLS using file format as binary but I am unable to look at data.

You cannot transfer data by using Binary as source if you took binary as source your sink also should be binary format and SQL server table is not a binary format.

Upvotes: 0

Related Questions