Re: Writing to file

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 04/18/04 

Date: Sun, 18 Apr 2004 08:24:29 -0400

As Hari says, BCP is fine... It's fast, supported, and has been part of the
product since the beginning... Use BCP if it suits you.. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Leandro Loureiro dos Santos" <nao@falo.com.vc> wrote in message
news:eESj78%23IEHA.3704@TK2MSFTNGP11.phx.gbl...
> Hello everybody,
>
> I would like to write a table to file, but i dont like to use DTS.
> I thought about to use a bcp command ... is tha a good idea?
> Or ... to use a generic DTS to write files ... and send the table and file
> to write from.
>
> Thanks
> Leandro L S
>
>

Relevant Pages

  • RE: pcb out file datetime format
    ... Since the datetime column was stored with 8 bytes, I think that you were using native storage file type to save the bcp output and you wanted to read the output file. ... Microsoft Online Community Support ... or a Microsoft Support Engineer within 1 business day is acceptable. ...
    (microsoft.public.sqlserver.tools)
  • RE: Importing Fixed Width Files with Multiple Occurrences
    ... I got it to work by deleting the BCP.exe file in my SQL 2000 ... I have checked the bcp utility at my computer. ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.dts)
  • bcp out in UTF-8 format
    ... I have SQL Server database tables with international character ... support. ... Is there any way I bcp out the table in UTF-8 format csv ...
    (comp.databases.ms-sqlserver)
  • RE: System.OutOfMemory Exception
    ... Consider creating a view in SQL Server that gets the data in the correct ... format and use a Process object to fire BCP to pull from this view. ... > to be "re-horizontalize" and served in a single flat file. ...
    (microsoft.public.dotnet.faqs)
  • RE: System.OutOfMemory Exception
    ... Consider creating a view in SQL Server that gets the data in the correct ... format and use a Process object to fire BCP to pull from this view. ... > to be "re-horizontalize" and served in a single flat file. ...
    (microsoft.public.dotnet.languages.vb)
Loading