DTS_E_InducedTransformFailureOnError when running SSIS package in another environment

0

I have an SSIS package which runs fine in the development environment, but after deploying to and running in the QA environment, it's returning a

Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The 'component 'SAS...' failed because error code 0x80004002 occurred, and the error row...

I've compared the tables on the dev SQL server with those on the QA sql server, and both appear to match, so I'm not sure what's causing this error.

ssis
asked on Stack Overflow May 13, 2013 by daniness • edited May 28, 2015 by Mike G

1 Answer

0

Either your environment or your data likely differs in QA.

If it is the environment, there is a .NET framework version issue discussed here, for which a hotfix is available here.

There is a separate data-dependent issue discussed here.

answered on Stack Overflow May 13, 2013 by criticalfix • edited Apr 13, 2017 by criticalfix

User contributions licensed under CC BY-SA 3.0