How to put first 4000 symbols from string to field?

Sergey Ufimtsev 1

Hello! I have a table in azure sql with field type nvarchar(4000) and i am getting data from api with copy command and some times data from api has more than 4000 symbols and i want to store first 4000 symbols or default value "data too long".

How can i achieve this?

HimanshuSinha-msft 19,471 Reputation points Microsoft Employee

2021-03-02T22:09:50.4+00:00

Hello @Sergey Ufimtsev ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .

Thanks
Himanshu
Himanshu Sinha 11 Reputation points

2021-03-08T21:43:30.723+00:00

Hello @Sergey Ufimtsev ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .In case if you have any resolution please do share that same with the community as it can be helpful to others . Otherwise, will respond back with the more details and we will try to help .

Thanks
Himanshu

1 answer

HimanshuSinha-msft 19,471 Reputation points Microsoft Employee

2021-02-26T23:40:32.64+00:00

Hello @Sergey Ufimtsev ,
Thanks for the ask and using the Microsoft Q&A platform .
Have you tried the option of "allow data truncation " under mapping ? I am adding snaphot below .

Please do let me know how it goes .
Thanks
Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members
Please sign in to rate this answer.
Sergey Ufimtsev 1 Reputation point

2021-03-14T22:54:15.953+00:00

Hello! Sory for long respond. i have no any data truncation field in mapping section

Sergey Ufimtsev 1 Reputation point

2021-03-14T23:14:37.557+00:00

My data source is http and sink is azure synapse analytic
Sign in to comment

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

Share via

How to put first 4000 symbols from string to field?

1 answer

Your answer