This is a
(*) PERSISTANT
(*) UNRESOLVED
(*) ILL EXPLAINED PROBLEM WITH SQL SERVER.
THE POSTED WORKAROUNDS DO NOT WORK.
THE SUGGESTED SOLUTIONS ARE IDIOTIC AND BASICALLY MAKE EVERYTHING
WRITTEN ABOUT DTS USELESS!!!!
Let me document:
0) The problem: http://support.microsoft.com/default...;EN-US;Q279857
1) The thread on it goes on for years.
2) Microsoft ( kb ) claims that its fixed in sql7sp3.
3) Users of sql200sp3 ( me ) report it up to this day.
4) This user has tried all the workarounds, is not using Data Pumps or
DTS and THE PROBLEM IS STILL THERE:
http://groups.google.com/groups?q=39...tngxa04&rnum=3
HOW CAN THIS BE?
IS DATA IMPORTING WITH RULES NOT A CENTRAL PART OF DATA MANAGEMENT
COULD MICROSOFT BE A MORE INEPT DATABASE CORPORATION.
IF THEY FOOL ENOUGH PEOPLE INTO USING THEIR BUGGY PRODUCTS VIA LOWBALL
PRICES ARE WE GOING TO BE LEFT WITH THE WORLD DATABASE ON THE PLANET
???????