Post reply

SSIS Transaction Error

  • April 19, 2017 at 4:01 am

    #322971

    I have a Zip File which contains .CSV files .Each .CSV will be mapped to respective Sql Server Table.

    I have enabled transaction option required once the files are unzipped .If any thing goes wrong entire zip contents should be rolled back.

    Following are the steps which are followed in building ssis Packagae

    1. Unzip the file
    2. Seq container Transaction Option set =required Isolation level :Serializable
    3. Delete data in tbl1,tb12,tb13 2.1 Iterate through csv files which has tb2.csv ,tbl2.csv,tbl3.csv
    4. DFT - Based on table name csv willto tb1,tb2.tb3 of sql server (OLEDB dest)

    Note: In Oledb destination

    1.Table/view Fast load option is set
    2.Identity are checked in
    3.Table Lock is not checked

    I am getting below error : Hresult: 0x80004005 Description: "This operation conflicts with another pending operation on this transaction. The operation failed.".

    Please suggest a way to overcome this error.

  • April 19, 2017 at 4:05 am

    #1938750

    Duplicate of https://www.sqlservercentral.com/Forums/1871557/SSIS-Transaction-Error

    Please keep your question to one topic. 🙂

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

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

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