error in BCP - 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 2005 Forums

SQL Server Administration (2005)

error in BCP

Author

Topic

ramesh31
Starting Member

11 Posts

Posted - 2007-06-07 : 15:13:25

EXEC MASTER..XP_CMDSHELL 'BCP "SET FMTONLY OFF SELECT * FROM ##tbtoFlat" OUT "\\10.96.36.219\iNVDAT\C.xmt" -c -q -U"cednetapp" -P"Ced6NA"'

Above bcp command generates error:

output
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQLState = 08S01, NativeError = 233
Error = [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.

NULL
SQLState = 08S01, NativeError = 233
Error = [Microsoft][SQL Native Client]Communication link failure
NUL

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-07 : 15:24:18

Are you just trying to get column information? Why do you have the SET FMTONLY option?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

ramesh31
Starting Member

11 Posts

Posted - 2007-06-07 : 15:28:19

yes i want only the column information, without "SET FMTONLY off" I get
error "BCP host-files must contain at least one column"

dinakar
Master Smack Fu Yak Hacker

2507 Posts

Posted - 2007-06-07 : 16:28:11

Have you looked into syscolumns?

Dinakar Nethi
************************
Life is short. Enjoy it.
************************
http://weblogs.sqlteam.com/dinakar/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources