Re: Problem with big data transfer

How are you transferring the data?

I have used BCP, DTS and T-SQL to "transfer" data from one location to
another. I have successfully transferred more than 10x the data you are
talking about. I used T-SQL for table-table transfer (within the same
server) and DTS for server-server transfer.

--
Keith


"oLiVieR CheNeSoN" <ocheneson@xxxxxxxxxxx> wrote in message
news:uNrXWVySFHA.3176@xxxxxxxxxxxxxxxxxxxxxxx
> Hi,
>
>
> I have MSSQl 2000 , SP3 with WIn2000
>
> when I transfer from one table to another, 115852 records, le server
> hangs.
>
> I tried with 70000 records and it worked. even with 90000 records.
>
> With more than 90000 records, the server hangs.
>
> Any idea ? It might be a bug in MSSQLsvr ? any known bugs ?
>
> Thanks for your help
>
> Olivier
>
>
>


.

Relevant Pages

  • Re: DTS Package run from Access on a different server: Error -2147467259; access denied
    ... The easiest way to get a package to run on the server is to go via T-SQL. ... > Is there a way of triggering a DTS package in SQL Server (so that the ...
    (microsoft.public.sqlserver.dts)
  • Re: deletion mistake
    ... Restore the database from a backup to another server or ... another database. ... database using DTS or T-SQL. ...
    (microsoft.public.sqlserver.security)
  • Re: ActiveX DTS not working on Schedule
    ... DTS package. ... comes with SQL Server due to the bug in 2000 which corrupts the DTS ... '  This script uses FTP to move a file from the transfers directory ... If not errorlevel 1 If not errorlevel 2 goto 226_ok ...
    (microsoft.public.sqlserver.dts)
  • Unable to enlist in the transaction.
    ... When i execute the same DTS job on another server not running SQL Server I ... Unable to enlist in the transaction. ... Help file: sqldts80.hlp ...
    (microsoft.public.sqlserver.dts)
  • Re: using access schema ini with DTS
    ... and yes I refresh the access database... ... SQL Server and with a scheduled event. ... Col2="PartNumber" Char Width 16 ... Underneath the covers of a DTS ...
    (microsoft.public.sqlserver.dts)