Home Forums SQL Server 2008 SQL Server 2008 - General SSIS Rollback Transaction RE: SSIS Rollback Transaction

  • October 25, 2010 at 5:08 am

    #1241488

    fenwicc (10/22/2010)

    We have some ETL jobs that feed our data warehouses. If you try to insert a duplicate primary key, the primary key constraint should cause the update to fail. Do you have a primary key on the destination table?

    Hi

    I think you did not see my post there i have created the table with pimary key only thats why i am getting error but i need to rollback whole transaction i am able to insert 6 records,7th record is duplicate in the example so the whole process sholud not insert.

    Thanks

    Parthi

    Thanks
    Parthi