Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
FreeHansje
Starting Member
3 Posts |
 Posted - 2005-12-29 : 04:18:57
|
| Hi there,I have this Dta Transformationtask, which creates duplicate key and I cannot find out why. If I take the SELECT statement from the SOURCE-tab and run it in QA I get no duplicates. The destination is correct, the transformation is ok, as far as I can see. When I run the complete step, I receive the Duplication Error message. So I delete the primkey from the targettable, the step is executed and yes, some entries are duplicated... Some, not all; until now I have not found why some entries are duplicated, but most are not.I would appreciate suggestions on how to check each step in the task other than the standard options in DTS.Greetz,Hans Brouwer |
|
|
FreeHansje
Starting Member
3 Posts |
Posted - 2005-12-29 : 05:23:58
|
| I think I have found what is wrong, tnx.Greetz,Hans Brouwer |
 |
|
|
|
|
|
Duplicates problem witrh DTS...