Search code examples
sql-serverssissql-server-agent

SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR with Code: 0xC020901E

I have an SSIS package that runs perfectly fine on Visual Studio 2013 but when I deploy the package to SQL server agent and execute it there I get the following error:

Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "Lookup" failed because error code 0xC020901E occurred, and the error row disposition on "Lookup.Outputs[Lookup Match Output]" specifies failure on error. An error occurred on the specified object of the specified component.

The package is running on Sql Server 2014.

Solution

  • I changed how to handle the rows with no matching entries to Redirect rows to no match output.The default was set to fail component.