Problems running SSIS job
Hi,
I'll be pretty quick! I have this error when running a job:
Message
Executed as user: domain\account. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 22:32:45 Error: 2011-06-28 23:22:21.55
Code: 0xC0202009 Source: DFT - Insert, Update Contact Insert Destination [7997] Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.
Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Could not complete cursor operation because the table schema changed after the cursor was declared.". End Error Error: 2011-06-28 23:22:21.56
Code: 0xC0209029 Source: DFT - Insert, Update Contact Insert Destination [7997] Description: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (8010)" failed because
error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (8010)" 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. End Error Error: 2011-06-28 23:22:21.56 Code: 0xC0047022 Source: DFT - Insert, Update Contact SSIS.Pipeline Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED.
The ProcessInput method on component "Insert Destination" (7997) failed with error code 0xC0209029 while processing input "OLE DB Destination Input" (8010). The identified component returned an error from the ProcessInput method. The error is specific
to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure. End Error Error: 2011-06-28 23:26:04.64 Code:
0xC02020C4 Source: DFT - Insert, Update Contact ODBS - Staging Contacts [1] Description: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020. End Error Error: 2011-06-28 23:26:04.64
Code: 0xC0047038 Source: DFT - Insert, Update Contact SSIS.Pipeline Description: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "ODBS - Staging Contacts" (1) returned error code
0xC02020C4. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing. There may be error messages
posted before this with more information about the failure. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 22:32:45 Finished: 23:26:04 Elapsed: 3199.36 seconds. The package execution
failed. The step failed.
Can someone point me out what might this be? It "says" nothing to me.
Thanks,
Nuno Silva
Nuno Silva
June 28th, 2011 6:50pm
There's a couple errors there - one of which I haven't seen with respect to SSIS, but I'll describe it to you. (I've seen it in plain T-SQL coding before.)
First, the error complains about being unable to use a cursor because the table schema changed underneath what the cursor was enumerating. Are you using cursors in your package?
Second, there's an INDUCEDTRANSFORM error in there. This typically means that you've got a string that you're trying to shove into a date or integer typed column. In your case, it looks like you have a "data type A" in your data flow that you're
trying to shove into a "data type B" column in your database.
Hope that helps.
Talk to me now on
Free Windows Admin Tool Kit Click here and download it now
June 28th, 2011 8:15pm