Re: BCP Format Files

From: Vlad Vissoultchev (wqweto_at_nospam.myrealbox.com)
Date: 05/01/04 

Date: Sat, 1 May 2004 22:03:05 +0300

>> Don't think I have ever used a format file for an extract. bcp will take
a query and you can use that to format the data. <<

i never managed to import native format bcp files w/o a format file.
probably this is the case with the original question.

anyway, fmt files are relatively easy to produce from information_schema
metadata. i once planned on implementing an sp but solved my problem
manually and never found the time :-))

cheers,
</wqw>

Relevant Pages

  • Re: bcp problem
    ... You could try using a format file, where the column delimiters would be ... qualifiers be part of the delimiter and thus get stripped out. ... If you want to stick with bcp, then just try using the Bulk Insert Task, as ... > f text 16 nulls ...
    (microsoft.public.sqlserver.dts)
  • Re: Create Job to dump SP results into a text file.
    ... I am glad to hear that the osql works fine now. ... I use BCP to create a format file for the output (this could be ... ', type a name to generate the format file, I use ... create a table 'authorsx' to hold the result set of the stored ...
    (microsoft.public.sqlserver.programming)
  • Re: Create Job to dump SP results into a text file.
    ... > I am glad to hear that the osql works fine now. ... > 2) using BCP to save the content of this table to a tab limited log file ... ', type a name to generate the format file, I use ... create a table 'authorsx' to hold the result set of the stored ...
    (microsoft.public.sqlserver.programming)
  • Re: error while using bcp...
    ... I would look at the format file, or carefully walk step by step if ... From here it appeared bcp is ... A query like this can help to determine the offending row ... Use prefix length, termination string, or a larger host-file field size. ...
    (microsoft.public.sqlserver.programming)
  • Re: BCP Troubles
    ... The SQL server we are tying to BCP into is SQL 2000. ... > way I got it to work was to run BCP and have it create a ForMaT file. ... So it sounds like the first time BCP is not executed at ...
    (comp.databases.ms-sqlserver)