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,381 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,381 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