|
|
|
SSC-Enthusiastic
      
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 11:32 AM
Points: 195,
Visits: 70
|
|
|
|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Friday, May 03, 2013 3:04 PM
Points: 12,
Visits: 95
|
|
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
|
|
|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Monday, April 18, 2011 5:08 PM
Points: 410,
Visits: 7
|
|
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
|
|
|
|