ROLLBACK in SSIS

• pritesh2205

  Ten Centuries

  Points: 1355

  More actions

  April 12, 2008 at 9:49 am

  #205699

  If a load fails , while loading a verylarge file to a table, then how do we rollback the data that would be written to the table. Say 10 million rows need to be loaded to a table, the load fails after 7 million rows. How do we roll back to the initial stage so that integrity is not loast. Under what settings does a package runs to achieve this.

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  April 14, 2008 at 7:39 am

  #802062

  Hi,

  Follow the below links. I think this will help you out.

  http://www.sqljunkies.com/WebLog/knight_reign/archive/2004/12/12/5499.aspx

  http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/transactionsinsqlserver2005integrationservices/1653/

  http://blogs.conchango.com/jamiethomson/archive/2004/12/14/SSIS_3A00_-Package-transactions.aspx

  You can even search for Brian knight videos which shows you how to work with Package Transactions.

• Oracle_91

  SSChampion

  Points: 14548

  More actions

  April 14, 2008 at 7:59 am

  #802074

  Hi,

  This video helps you a lot in understanding the Transactions within SSIS

  http://www.jumpstarttv.com/Media.aspx?vid=39