how to quote null or int value in copy activity

Question

how to quote null or int value in copy activity

Liming Wang 1

I use copy activity to move data from sql database to BlobStorage(csv file).I also defined the csv file with double quote character in dataset.But when sql query result is null or int,it can't quote with double quote.

csv output result
"ab",1,,"ac"

csv expect result
"ab","1","","ac"

is there anyway to resolve the problem?

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-08-25T22:13:17.037+00:00

Hi @Liming Wang ,

Just checking to see if the suggestion from Vaibhav was helpful to resolve your issue? If that answers your query, please do consider to click “Accept Answer” and "Up-Vote" as it might be beneficial to other community members reading this thread. And, if you still need assistance do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-08-27T20:24:38.653+00:00

Hi @Liming Wang ,

Following up to see if you still need assistance on this query. In case if you have found a different solution other than Vaibhav's suggestion, please feel free to share it here with community, as it would help others reading this thread.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-08-27T20:27:29.743+00:00

Hi @Liming Wang ,

Following up to see if you still need assistance on this query. In case if you have already found a resolution other than Vaibhav's suggestion, please feel free to share it here with community, as it would help others reading this thread.

Thank you

1 answer

Your answer

KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-08-25T22:13:17.037+00:00

Hi @Liming Wang ,

Just checking to see if the suggestion from Vaibhav was helpful to resolve your issue? If that answers your query, please do consider to click “Accept Answer” and "Up-Vote" as it might be beneficial to other community members reading this thread. And, if you still need assistance do let us know.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-08-27T20:24:38.653+00:00

Hi @Liming Wang ,

Following up to see if you still need assistance on this query. In case if you have found a different solution other than Vaibhav's suggestion, please feel free to share it here with community, as it would help others reading this thread.

Thank you
KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator

2020-08-27T20:27:29.743+00:00

Hi @Liming Wang ,

Following up to see if you still need assistance on this query. In case if you have already found a resolution other than Vaibhav's suggestion, please feel free to share it here with community, as it would help others reading this thread.

Thank you

Answer 1

Vaibhav Chaudhari 38,916 Volunteer Moderator

So it is adding quotes only for string data. If quotes are needed for integer or blanks, nulls as well - you can try casting all the columns to string like SELECT cast(col1 as nvarchar(100) ...

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Share via

how to quote null or int value in copy activity

1 answer

Your answer