I am using a DTS package to copy a table from one server to another. The new
table has a few more bit fields set to allow nulls and a couple of text
fields also set to allow nulls. When run I get this in the log file:
Execution Started: 4/26/2005 11:31:19 AM
Error at Destination for Row number 63338. Errors encountered so far in this
task: 1.

Error Source: Microsoft OLE DB Provider for SQL Server
Error Description:Unspecified error
Error Help File:
Error Help Context ID:0
205676||0|L I N E L O C A T E |M |1| ...(the record goes on)
Execution Completed: 4/26/2005 11:38:23 AM

205676 is the primary key. The strange thing is when I change the source to
be just this record it loads without an error. What could be the problem?
Thanks