I create a local DTS package on SQL7.0 Server(sp4)which
import data from text file to a database table. I have
SQL7 enterprise managers installed on both my own PC
(windows 2000 professional) and the windows 2000 server
(which the SQL 7 server reside). When I ran from my pc's
enterprise manager (right click on the package and execute
it),it did import 888 rows of data, but if I ran from
windows 2000 server's enterprise manager, did the exact
same thing (right click and execute it),I got message
saying: "Successfully completed execution of package" and
status is:"888 rows have been transfered or copied". But
it really did nothing when I check the table,no row were
copied at all! It is really strange and I don't have a
clue why??? Thanks for any help.

Tie Zhu
416-866-5127
Technical Analyst
Finance,Scotiabank.

I found the problem. It's nothing wrong with the DTS ,it's
the default date format issue on different systems.
Instead of Nov 1st, 2003, it imported as Jan 11,2003.