Exception handling in DTS

• Jambu Krishnamurthy

  SSCrazy

  Points: 2054

  More actions

  December 12, 2006 at 10:54 pm

  #368562

  Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/kjambu/2762.asp

• Rafael H

  SSC Veteran

  Points: 273

  More actions

  December 20, 2006 at 11:23 am

  #679182

  Thank you!  Never used Multiphase Data Pump before so was a great introduction.  Very interesting object!  Also the article made me look at things I overlooked before, great.

  BTW, the error count before failure is (fairly?) exposed, I use it for a regular data pump and the Disconnectded Edit allows to enter a larger number manually.

  The problem I am having is that DTS does not fail on data type mismatch, but simply inserts NULL if say a nullable numeric column gets a char.  If anybody knows how to fix this please send me an email: rafael.public@comcast.net.  Thank you in advance.

  ---

  Kindest Regards,

  R

• jloesch

  Ten Centuries

  Points: 1004

  More actions

  December 20, 2006 at 7:28 pm

  #679294

  One correction - you mention that PK violations can be handled using the DTSLookup feature, but FK violations can't.  Actually, you can, and I have some packages that do just that.

  
  James C Loesch