Sync Package error Zoho to SQL Server, suspect destination column is to small.

  • 89Views
  • Last Post 20 August 2021
Lonnie Chin posted this 19 August 2021

I have encountered an error while running one of my sync packages that syncs data from Zoho to a table in SQL Server.  The sync has run trouble free for a long time but I am now recieving this error in the log.

ThisId;"OtherId";"Operation";"Error" ;"4302804000000424334";"i";"String or binary data would be truncated. The statement has been terminated."

From the information presented in the log I am assuming that an entry at the source is to large for the desitnation column in SQL Server but that is hard to tell.  When I search for this entry in the source I do not see this string. Is there anyway in the package that I can allow it to truncate or a way that I can identify the  column from source or the intended destination to assist me in finding the bad data point?


This is the link to the package -

Nataliia Nikulina posted this 20 August 2021

Hello Lonnie,


Thank you for contacting Skyvia Support team.


We have sent a reply to your mailbox. Please check it and let us know if you need any further assistance


Best regards,


Customer Support Engineer