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 |
|
tmarko
Starting Member
15 Posts |
 Posted - 2008-01-28 : 11:49:07
|
| The destination table is empty and I copy using DTS the corresponding table from an other dB. (Both databases looks the same . One is a test dB the other production. So the source and destination tabel looks the same Append rows to destination table is chosen. Both tables got foreign keys, and Enforce relationship for replication and Enforce relationship for insert and updates are checked. No index or constraintsAtter running it this comes up"Error at destination for Row number 2359097. Errors encountered so far in this task:1." This is by the way the last row in the source table. What can be the problem? |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-29 : 06:46:31
|
| Do you have an errorfile set up for this package?If so, you should get more information on which column this error is occuring on.If not, set one up. |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-01-30 : 03:56:22
|
| Adding to my earlier answer, which SP are you using? |
|
|
|
|
|
|
DTS problem