RE: BCP genric error
SalamElias (eliassal@xxxxxxxxxxxxx) writes:
Hi I figured out what is the problem. It was indicating the fullpath for
the format file. But now I am getting nothing entered in the table, when
I issue the bcp I get
*****************
Starting copy...
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
********************
So what is missing?
My interpretation is that the file is empty.
How does the format file look like? What sort file is it? A text file?
Binary?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
Relevant Pages
- 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) - 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: ISQL is truncating contents of text field sent to text file.
... At first we were inserting each FOR XML to a table ... to find a single solution compatible with SQL Server 2k & 2k5. ... After asking on usenet, and being suggested to use BCP, we now ... Books Online for SQL Server 2005 at ...
(comp.databases.ms-sqlserver) - Re: BCP cant export more than MAX_INT rows
... Still it's odd in this age of BIGINTs that bcp can only count to 2.1 ... 1000 rows successfully bulk-copied to host-file. ... I really hope that this happened with 32-bit SQL Server? ... Books Online for SQL Server 2005 at ...
(microsoft.public.sqlserver.tools) |
|
