Obligatory MS Technet article - Creating a DTS package . . .

(Assuming SQL 2000 since we're in the 2000 forum)

http://technet.microsoft.com/en-us/library/cc917688.aspx

Rather than perform "all" the tasks on the fly ....

On the destination server . . . for a test . . .

Can you manually copy a large file through the network share?

i.e. Use any workstation and connect to...