Info about tasks - 04-19-2005 , 12:29 PM
I have got a EXPORT task between a Sql Server to my local SQL (within one
same domain) and apparently everything is fine, it is doing a copy about 100
tables with an average of 2,000 rows per each table.
As you will see there is no locks or hindrances or something like that:
Source Sql Server task:
56 sleeping servers NWP-91 .
CO_WH_DEVE AWAITING COMMAND 78 238 04/19 18:25:18 DTS Import/Export
Destination Sql Server task:
56 RUNNABLE SERVERS NWP-91 . CO_WH_DEVE BULK
INSERT 364500 237066 04/19 18:25:20 DTS Import/Export Wizard 56
Definitely there is no tasks or processes running against the tables that
right now is being transferred as well as Front-End and Back-End applications
are closed (Visual Basic 6.0 app)
The question, maybe silly question, is the following: how could I know if is
there anything going wrong?
Thanks in advance and regards,