Re: BCP Troubles

dataguy (barry_noble@xxxxxxxxxxxxxxx) writes:
> It is happening everytime.

That's a good thing. :-) I mean this makes it easier to repeat. Could
you post the CREATE TABLE statement for table, sample data and the
format file. But please put the sample data and format file in a zip
file to attach that.

> I got a brainstorm and figured I could run a BCP and create the format
> file first prior to doing the BCP in.. When I tried running BCP with a
> format as the output I keep getting the following error:
>
> SQLState = S1090, NativeError = 0
> Error = [Microsoft][ODBC SQL Server Driver]Invalid string or buffer
> length
>
> Any suggestions?

BCP's error messages are sometimes very obscure. What was the command
you used to achieve this?

--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

.

Relevant Pages

  • Re: BCP import
    ... How can I tell BCP to ignore the surrounding double-quotation marks? ... You need to use a format file where you specify the double quotes as ... SQL Server MVP Linda Weirzbiecki. ... the integer column is not enclosed in quotes. ...
    (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)
  • RE: BCP genric error
    ... I issue the bcp I get ... How does the format file look like? ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • BCP Troubles
    ... The SQL server we are tying to BCP into is SQL 2000. ... I compared the ForMat file I created by hand,to the ForMat file I ... compare to check it). ...
    (comp.databases.ms-sqlserver)
  • Re: Cannot fetch a row from OLE DB provider "BULK" for linked serv
    ... If I can remove all embedded commas in the ... then BULK INSERT and the format file (after removing ... I could create an XML file. ... Learning to use XML in SQL Server ...
    (microsoft.public.sqlserver.programming)