DML error logging

• blom0344

  SSCrazy

  Points: 2053

  More actions

  February 1, 2007 at 6:24 am

  #194127

  Oracle 10g2 offers DML error logging, which enables to load data with traditional SQL without having a complete roll-back in case one record is refused.  http://orafaq.com/node/76

  This is almost similar to loading capabilities of ETL-tools (at least in the error-handling department)

  Does anyone have a clue whether Microsoft is going to add such functionality to SQL Server 2005?

   

• K. Brian Kelley

  SSC Guru

  Points: 114562

  More actions

  February 1, 2007 at 8:25 pm

  #687303

  This would be a question best asked of one of the SQL Server development teams at Microsoft. You can certain ask for it as a recommendation here:

  Microsoft Connect - SQL Server

   

  K. Brian Kelley
  @kbriankelley

• Jon Glickman

  Grasshopper

  Points: 16

  More actions

  January 17, 2011 at 2:53 pm

  #1274395

  I have screamed at the development team in MicroSoft when are you going to implement this incredible feature...

  insert a million or two rows and if one produces and error it goes into a error bucket and the rest succeed c'mon

  that's awesome and it works. Oracle's ODI data warehousing tool is based on Error Logging DML... how can SQL server

  even say they can compete with Oracle on this one. A must have for SQL servers next release...