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.
| Author |
Topic |
|
ramesh31
Starting Member
11 Posts |
 Posted - 2007-06-07 : 14:55:51
|
| EXEC MASTER..XP_CMDSHELL 'BCP "SET FMTONLY OFF SELECT * FROM ##tbtoFlat" OUT "\\servername\iNVDAT\CORP0001.xmt" -c -q -U"tapp" -P"emmmNA"'Above BCP command generates error:output---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------SQLState = 08S01, NativeError = 233Error = [Microsoft][SQL Native Client]Shared Memory Provider: No process is on the other end of the pipe.NULLSQLState = 08S01, NativeError = 233Error = [Microsoft][SQL Native Client]Communication link failureNULL-Thanks in AdvanceRamesh |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
|
|
|
|
|
error in BCP