Skip to main content

Error: 'string or binary data would be truncated'

What to do if you see a 'string or binary data would be truncated' error when opening or saving the plan, or importing data in Orchestrate.

Written by Arthur Ashdown

I cannot open or save the plan. The following error message generates:
​
​An unexpected error occurred. Please report this problem to your system.administrator with the following information:
​
System.InvalidOperationException: String or binary data would be truncated.

​
I cannot import data due to the following error:
​
​Orchestrate data flow import has failed. The detailed information is as follows:
​
String or binary data would be truncated
​
Import command:
EXEC [wf].[Populate_Staging_DB] @DataSourceName = 'StandardStagingDatabase' @DatabaseName = 'orc_StagingDatabase'

Please raise a new case online and reference the title of this article.

Did this answer your question?