[SQL Server 2008 issues] SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR |
| SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR Posted: 04 Aug 2013 12:26 PM PDT If I set the SSIS package to ignore the error this column pulls in null values instead of real values. If it's not set to ignore the error this is the error message. The data type is INT. It's failing in the ADO NET Source task. Any ideas? [ADO NET Source [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "ADO NET Source" (1)" failed because error code 0x80131937 occurred, and the error row disposition on "output column "XYZ" (749)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure. |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 - General / SQL Server 2008 To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment