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 - https://app.skyvia.com/#/53117/objects?type=package&folder=0