December 12, 2006 at 10:54 pm
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/kjambu/2762.asp
December 20, 2006 at 11:23 am
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.
R
December 20, 2006 at 7:28 pm
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply