Post reply

SSIS package Error DTS_E_OLEDBERROR

  • August 22, 2008 at 4:35 pm

    #191471

    hI

    I am getting following error while running SSIS package.

    I tried to google it out but was not able to find the solution.

    Appreciate your help on this.

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1071636471,0x,SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x00040EDA.

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1071607780,0x,There was an error with input column "COLUMN NAME" (728) on input "Excel Destination Input" (78). The column status returned was: "The value violated the schema's constraint for the column.".

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1071607767,0x,SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "Excel Destination Input" (78)" failed because error code 0xC0209076 occurred, and the error row disposition on "input "Excel Destination Input" (78)" 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.

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Excel Destination" (67) failed with error code 0xC0209029. 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.

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1071636284,0x,The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020.

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1073450952,0x,SSIS Error Code DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "SQL Query" (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.

    OnError,PA-PRMOLAP,VMWAREM\pa-prmolap,TapCompanyBatchNew,{400B7710-5DCF-4DEC-81BF-F83892EF6F34},{F89F9AA2-12DB-4A0A-823E-67CA5F1E848F},8/22/2008 3:31:48 PM,8/22/2008 3:31:48 PM,-1073450975,0x,SSIS Error Code DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code 0xC0047038. There may be error messages posted before this with more information on why the thread has exited.

    thanks

    Nilesh

  • August 22, 2008 at 4:45 pm

    #862152

    If you see the actual error is “The value violated the schema's constraint for the column”

    This means that, there is foreign key violation in the destination.

    Column: "COLUMN NAME" (728): "Excel Destination Input" (78).

    Please check all reference values are present in the target table.

    ------------------

    Do not worry about reset of the messages. 🙂

  • August 22, 2008 at 4:54 pm

    #862154

    Sarang,

    I have one query which has few columns which are more than 2000 in length. I don't have any constraint on excel sheet. So there is no foriegn key on excel table.

    What can be the cause then?

    thanks for responding

    Nilesh

  • August 22, 2008 at 5:07 pm

    #862158

    Nilesh,

    Can you tell what exactly you are trying to achieve?

    I think it is a data issue. If you are sure that it’s not a foreign key issue then check for the Nulls. It may be causing the problem.

    Hope this helps 😉

  • August 22, 2008 at 5:33 pm

    #862162

    Hi,

    When I create the Excel table using DTS package for the same SQL Query it works but when I use SSIS to create excel table it fails.

    so I used the DTS Query for now.

    The difference I found was I replaced the nvarchar(2000) with longText. It worked 🙂

    Thanks for your help

    Nilesh

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply