question

DivyaRajendran-5109 avatar image
0 Votes"
DivyaRajendran-5109 asked DivyaRajendran-5109 edited

How to use bcp native format exports in datasources in ADF

Hi All,

I have some ".dat" file exports created using a bcp command with "-n" option. I am trying to load these files and copy the data into Synapse using ADF.

I see funny characters in places where bigint, int, or near any non-character data.

What all options should I select in a data source in ADF to read this data properly?

azure-data-factory
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @divyarajendran-5109,

Welcome to Microsoft Q&A forum and thanks for posting your query.

Were you able to export a .DAT file to .TXT file using ADF? If so I would recommend to verify/compare the files exported using bcp commands Vs regular .DAT file to see if there is a difference between them.

Do let us know how it goes.

0 Votes 0 ·

Hi @KranthiPakala-MSFT

I can write the data to a text file if that is what you mean. But, even then I am unable to read these ".txt" files which were created using bcp export command.

Could you please suggest a way to read any format file which was exported using a bcp export command with -n argument.

Thanks,
Divya

0 Votes 0 ·

Hi @divyarajendran-5109,

I'm not an expert with .DAT files, but would like to check if there is a difference between regular .DAT files and the bcp command exported .DAT files? I'm also reaching out to internal team to check if the files exported using bcp commands are the issue here and will get back to you soon. In the meantime if you get a chance to verify the difference between regular DAT file and the file exported/generated using bcp export command do let us know.

Thank you

0 Votes 0 ·
Show more comments

0 Answers