October 5, 2009 at 7:31 pm
I did a package for one table to copy the data,my DTS package is runs normally during data tranferring from database A to B on the same server,it show Package Execution Completed when proceess is completed.My problem is why the rows transferred not same before and after when I count one of the field in the table.
Data from source Table - 906927
Data from the destination table - 906754
Pls anyone help me on this problem.
Dwen
October 5, 2009 at 8:57 pm
You'd have to provide more details, and likely log things from the package.
Was the destination empty?
What was the transfer method? Any dups? Any PKs issues? continue on error? batch size? There are lots of possibilities for why the counts might not match.
If it's a simple transfer of the entire table, everything should move.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply