Re: SQL Import of LArge Amount of Data



In Books on line, do a search for bcp or BULK INSERT

http://sqlservercode.blogspot.com/

.



Relevant Pages

  • Re: SQL Import of LArge Amount of Data
    ... bigger use BCP or BULK INSERT ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: bcp native format file from DTS
    ... I called that views from bcp to load data in flat files as native ... After that while loading them in sql tables using Bulk Insert i am ... > And here is an example of manipulating the ExecuteProcess task. ...
    (microsoft.public.sqlserver.dts)
  • Re: Data Transfer
    ... Native mode is usually the cleanest and easiest to work ... BCP, BULK INSERT etc. ... >>>Andrew J. Kelly SQL MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: bcp native format file from DTS
    ... I called that views from bcp to load data in flat files as native ... After that while loading them in sql tables using Bulk Insert i am ... > And here is an example of manipulating the ExecuteProcess task. ...
    (microsoft.public.sqlserver.dts)
  • Re: BCP format file
    ... There is no way you can do this with BCP, ... use the bulk copy API and bulk from variables. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)

Loading