SSIS Error: Failed because truncation occurred

Error:

[List of apps [2]] Error: The “List of apps.Outputs[Flat File Source Output].Columns[ Summary]” failed because truncation occurred, and the truncation row disposition on “List of apps.Outputs[Flat File Source Output].Columns[ Summary]” specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

Solution:

Go to data source–>Error output tab–>Under the Truncation column, and choose the correct SQL table column name and then select “Ignore Failure”

Advertisements

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 )

Google+ photo

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

Connecting to %s