Post reply

DTS Import/Export hangs

  • September 23, 2005 at 6:00 am

    #67048

    I am using the DTS Import/Export wizard to transfer data from a table on my local server to a server in Sweden.  The table has 9980987 rows.  I use a query to specify the data to transfer.  Select * from <tablename>

    The transfer progresses up to approximately 9980000 after about 45 minutes and then hangs there.  I click on cancel and then it still runs approximately another 45 minutes before control is returned and it displays the window that the transfer is complete.  When you check the table on the server in Sweden, the rowcount is 9980987.

    I would schedule this task but can not until I work out why it is hanging.  Does anyone have any suggestions on what could be the cause and how to resolve it?

    Thanks

     

  • September 23, 2005 at 6:21 am

    #592565

    If you run the DTS, it's always depend on your network bandwidth, for your case i think it's good if you use a FTP. You can create a DTS to extract the data to the csv or other format, and then copying that file to the destination server with the FTP. The destination server must have a DTS to read the new file, and then restore itself.

  • September 23, 2005 at 7:04 am

    #592580

    Thanks for your advise.  I will give that a try.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply