Home Forums Data Warehousing Integration Services How to restrict to stop the package if one of the excel tab gives error RE: How to restrict to stop the package if one of the excel tab gives error

  • December 20, 2012 at 5:30 am

    #1570498

    sqlstud (12/20/2012)

    Koen Verbeeck (12/20/2012)

    Enable transactions in your SSIS package. You can either use the built-in transaction mechanism which uses MSDTC, or you can create your own transaction by putting a SQL Task with "BEGIN TRANSACTION" at the start of your package and a SQL Task with "COMMIT" at the end of the package. Make sure you set RetainSameConnection to true for the connection manager.

    Thanks MCSA.

    Can you please let me know how to do it?

    Regards

    SqlStud

    One way of mainitaining explicit transaction Koen has already mentioned by putting Exec SQL Task.

    For the first one please refer below URL

    http://technet.microsoft.com/en-us/library/cc304421.aspx