Post reply

Error code: 0x80040E21.

  • June 12, 2014 at 8:24 am

    #294431

    Hi all,

    I am having .csv as my source which contains millions of records. almost 400000 records are loading into table and after package is failing due to below error.

    [OLE DB Destination [9]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.

    An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80040E21 Description:

    "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".

    Can you please suggest any idea to getting rid on that.

    Thanks

    Abhas.

  • June 19, 2014 at 3:11 pm

    #1723426

    Someone posted this answer in previous post on your error.

    Here's below answer.

    Hi the below steps might help to solve issue more quickly.

    1.Use the OLE DB Destination.

    2.Use the "Table or View - fast load " as data access mode.

    3.Check “Keep nulls” and “Table lock” property, and keep the other properties unchecked.

    4.Map the new converted columns to SQL destination table columns.

    Thanks:-)

    Viresh
    --------------------------------------------------------------------------
    “ The future belongs to those who are virile, to whom it is a pleasure to live, to create, to whet their intelligence on that of the others. ”
    — Sir Henri Deterding

Viewing 2 posts - 1 through 1 (of 1 total)

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