BCP Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

BCP Error

Author

Topic

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-01-24 : 20:51:36

Hi all,

Here i have used BCP for in & Out puropse
EXEC xp_cmdshell 'bcp "perdb.dbo.cst" out c:\KK.txt -n -Usa -Ppass';
Exec xp_cmdshell 'bcp perdb.dbo.cst_tmp in c:\KK.txt -c -SCOVEY11 -Usa -Ppass'

The first query has executed successfully
but the second query returns the error like

output
---------------------------------------------------------------------NULL
Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
NULL
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
NULL

(9 row(s) affected)

Can any one able to help me please
Thanks
Krishnakumar

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-24 : 20:54:57

you output using -n (native type) and input using -c (char type) ?

CSK
Constraint Violating Yak Guru

489 Posts

Posted - 2007-01-24 : 20:59:06

Please Ignore!!!!!!!!!!!!!
I got the mistake I have given a parameter (-n) as Nativetype

Regards
Krishna

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources