Post reply

How to Roll Back?

  • June 13, 2012 at 3:28 am

    #257588

    Hi Friends,

    I have 4 data flow tasks which are pointed towards the same destination. if any of the data flow is ended with error, the error data flow task alone must roll back. i mean it should not insert any data into the destination. Because if any error occurs when it is started to insert , then i need to delete whole records and have to rerun. So how to save my time by debug the errors?

    give me your valuable sugesstions, friends..

    Thanks,
    Charmer

  • June 13, 2012 at 3:38 am

    #1500227

    Pre-load all data with all required validations into staging tables. When done, you can load it into destination if there are no errors.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • June 13, 2012 at 3:49 am

    #1500230

    Eugene Elutin (6/13/2012)

    Pre-load all data with all required validations into staging tables. When done, you can load it into destination if there are no errors.

    Thanks Eugene..

    but when i googled about this, they are mentioning about transaction potion and set package level to fail...

    would that help me?

    Thanks,
    Charmer

  • June 13, 2012 at 3:55 am

    #1500234

    It will help, but, will it satisfy your performance requirements (if any)? It is really depends on what you load and what transformations and validation you perform. I am not very big fan of SSIS for serious ETL loads.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]

  • June 13, 2012 at 4:04 am

    #1500238

    Eugene Elutin (6/13/2012)

    It will help, but, will it satisfy your performance requirements (if any)? It is really depends on what you load and what transformations and validation you perform. I am not very big fan of SSIS for serious ETL loads.

    performance is not a big deal in my work...lets imagine that i have single data flow task..if it fails, i want this to roll back..

    how can i do this, Eugene? (let me take using staging table as 2nd option...)

    Thanks,
    Charmer

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

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