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 8:34 am

    #1570574

    rhythm.varshney (12/20/2012)

    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

    Thanks....

    But it didnt solved the problem.

    it given the error as "

    [Connection manager "src"] Error: The connection does not support enlisting in distributed transaction. "

    Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "Src" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    Regards

    SqlStud