Error: The “Excel Source.Outputs[Excel Source Output].Columns[columnname]” failed because truncation occurred

SSIS error occurred due to truncation occurred at Excel Source in SQL Server

Excel Source has a problem during running and throws the following error:

Excel Source [16]] Error: The "Excel Source.Outputs[Excel Source Output].Columns[Project SharePoint Site]" failed because truncation occurred, and the truncation row disposition on "Excel Source.Outputs[Excel Source Output].Columns[Project SharePoint Site]" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

Solution:

  1. Go to the Data flow tab and right-click the “Excel Source”.
  2. Go to the “Show Advance Editor”.

3. Go to the Input and Output Properties tab. Expand the Output Columns and select the column in which you need to change the datatype.

4. Select the column and change its datatype as follows: I increase the length to 4000 as i required and change to Unicode string[DT_WSTR]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.