SSIS – No status is available (NonColumnSpecificError)

In case your SSIS package fails to insert new records into a destination table and you receive an error message like:

No status is available.
[NonColumnSpecificError]

In my case, the Error Description (custom) component returned this message and wrote it to my errors-table:

SSIS-Error-Description-Component

SSIS-No-Status-Is-Available-NonColumnSpecificError

More info about this component can be found here.

It’s probably a Foreign Key (FK) constraint, you might want to check those.


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