April 4, 2006 at 10:01 am
Hey gang,
Does anyone know what error the heck 0xC0209029 and 0xC0047021 means? MSDN2 fails me again. They translate to DTS_E_INDUCEDTRANSFORMFAILUREONERROR and DTS_E_THREADFAILED but that does not tell me why the OLE DB destination fails.
Well, this SSIS is slow going. I can't manage to get my SSIS package to actually insert anything. I've even simpliefied the data flow by using a SQL command with joins (instead of the OLE DB table source thinking maybe the command will bypass conversion issues) and removing the lookups. But the OLE DB destination clearly gets 6 rows and never inserts anything, I set it to fail on error and get the error 0xC0209029 but nothing tells me what the problem really is. The row data *looks* correct. Even a type conversion or some other useful error would help.
I also tried making a very simple version of the package with the Import Wizard to see how the pro does it, but it also used an OLE DB SQL Command Source and even that one failed with 0xC020907B, DTS_E_OLEDBDESTINATIONADAPTERSTATIC_UNAVAILABLE, though all the connections test OK.
Thanks for the help, this is all way too strange to me still.
Skål - jh
April 4, 2006 at 2:41 pm
Oh good grief. This was a harder day than expected. Seems, bottom line, those errors are meaningless all they tell you is "there was an error and the box is gonna turn red".
Finally I added an error file out put and got some better clues.
Hit the limit for the implicit conversion in the OLE DB Dest. It looks like it cannot deal with NText going into NVARCHAR. Why my source DBA wanted little fields like 'first name' to be NTEXT is beyond me, but adding in a data converter and converting the NTEXTs that had to fit into a NVARCHAR did the trick.
I'm keeping my fingers crossed for better error messages in SP1. Now it's on to the other fun SSIS things which aren't doing anything either. La lucha continua.
Skål - jh
April 13, 2007 at 6:31 am
0xC0209029 = DTS_E_INDUCEDTRANSFORMFAILUREONERROR means
The "__" failed because error code 0x__ occurred, and the error row disposition on "__" specifies failure on error. An error occurred on the specified object of the specified component.
and
0xC0047021 = DTS_E_THREADFAILED means
Thread "__" has exited with error code 0x__.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply