BCP Not giving Desired output.

Rakesh Dhar 96

![80468-microsoftteams-image.png][1] [1]: /api/attachments/80468-microsoftteams-image.png?platform=QnA Hi all , Attached is the Output of a BCP Command . which is not the correct one . the marked line should be the first row .which is coming in middle of the .csv file. We are converting a .xlsx file to .csv file using rowset command and BCP command . let know what other details required..

Viorel 118K Reputation points

2021-03-23T07:15:38.72+00:00

If you have a SELECT and UNION statement, then show some details, because the problem can be probably solved by adding an ORDER BY.
Rakesh Dhar 96 Reputation points

2021-03-23T07:30:27.77+00:00

the marked line is the data row .. which is supposed to be the first row in the converted .csv file .
sure ...i will try to put the order by .and will check.
Rakesh Dhar 96 Reputation points

2021-03-23T07:36:00.373+00:00
-c -t , - T -S

these are the parameters what we are using
Tom Phillips 17,741 Reputation points

2021-03-23T12:53:06.037+00:00

If you do not use ORDER BY, there is no order. If you need it output in a specific order, you must use ORDER BY.
Rakesh Dhar 96 Reputation points

2021-03-23T13:05:59.637+00:00

One more thing ..how can we let the BCP to generate the .csv file in UTF-8 Encoded format . right now i checked the CSV upload into table after change it into UTF-8 Manually . do we have option in BCP.
Tom Phillips 17,741 Reputation points

2021-03-23T13:46:10.813+00:00

See:

https://support.microsoft.com/en-us/topic/kb3136780-utf-8-encoding-support-for-the-bcp-utility-and-bulk-insert-transact-sql-command-in-sql-server-2014-sp2-fc6706f2-3ceb-0dc2-425e-af4da42a45a1
CathyJi-MSFT 22,306 Reputation points Microsoft Vendor

2021-03-26T06:15:56.423+00:00

Hi @Rakesh Dhar ,

Any update for this thread? Just checking in to see if the answer(s) helped. If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.

And If you have further questions or issues please let us know.

2 answers

Erland Sommarskog 112.7K Reputation points MVP

2021-03-23T23:01:39.033+00:00

There is not much information in your post to work from. We don't see your tables and queries etc, so we are left to guessworks.

However, I have an article about the bulk tools on my web site, that you may find helpful and could answer some of your questions: Using the Bulk-Load Tools in SQL Server.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
CathyJi-MSFT 22,306 Reputation points Microsoft Vendor

2021-03-24T09:37:13.177+00:00
Hi @Rakesh Dhar ,

> One more thing ..how can we let the BCP to generate the .csv file in UTF-8 Encoded format . right now i checked the CSV upload into table after change it into UTF-8 Manually . do we have option in BCP.

Using below T-SQL

bcp table_name out "drive:path\file_name" -c -C 65001

Suggest you read the blog that Erland mentioned.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

BCP Not giving Desired output.

2 answers

Your answer