Re: faster way to write tables?

If you will deal with millions of records and speed is really matter then
you should consider these options:

1.. DTS
2.. BCP
3.. IRowsetFastLoad


.

Relevant Pages

  • Re: Efficiently handle mass updates
    ... I suggest you investigate BCP or DTS. ... actually buy SQL Server just to get DTS as it can save a great deal of time ... > before in VBA and it was way quicker. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Dynamic Transforms
    ... This is a Q often asked and in this release of DTS it is a painful ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. ... In the past I have used BCP and altered> the various parameters when exporting from SQL Server. ... BCP is not> an option this time as he source is RedBrick. ...
    (microsoft.public.sqlserver.dts)
  • Re: avoid using BCP for snapshot
    ... with bcp you have to bcp into the file ... system and then bcp from the file system to the server. ... for a single table with DTS is is blasted over as a rowset. ...
    (microsoft.public.sqlserver.replication)
  • Re: BCP
    ... If you can schedule a DTS using Enterprise Manager, ... Set it up and make sure it works independently of the rest of the DTS before ... >> You sould execute BCP from a client, not from within a stored procedure. ... >> 'Server' as a linked server, ...
    (microsoft.public.sqlserver.programming)
  • Re: Export to File: no headers/trailers
    ... And how do you put a DTS or BCP in a job so it is executed every day ... >> Tanghe, Wendy ...
    (microsoft.public.sqlserver.server)