Error on import: String or binary data would be truncated. The statement has been terminated

ISSUE

Upon importing a default template from Excel, the following error appears on Step 5:

The import did not complete successfully. The following error was encountered: String or binary data would be truncated. The statement has been terminated.

CAUSE

Question labels are limited to 100 characters. If there is a question label that exceeds 100 characters then this error will be displayed.

SOLUTION

Decrease the amount of characters in the question label and perform the import again.