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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-26 : 08:02:28
|
| Dave writes "I want the output of BCP to not be written to a file, but instead be input to another program. Similiar to the unix concept of a named pipe. This is SQL Server 2000.For example:1) bcp nztest.dbo.Table1 out c:\table1.txt -c -t "|" -Usa -PsaThis creates the output correctly.2) Next I have another pgm (really irrelevant as to what it is)that can take that file and do what I want with it.xyz123 -t table1 -delim "|" -host xyz23230 -db daveb -df c:\table1.txtThis works as well.What I want to do is eliminate the 'landing area' of the bcp so it will not have to write to disk. We don't have the room for the files, and it makes no sense anyway as the only reason I want it is to feed something else.Is there something I can put after the 'out' to tell bcp to direct the output to another program? Even if I can get bcp output directed to the screen I should be able to just pipe it to the receving program (I think).Thanks!" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-26 : 08:04:15
|
| Yeah, I wish this was possible too, but it's not. bcp only writes out to files. As far as disk space, write a batch file to do everything and include the relevant delete statements at the end. |
 |
|
|
|
|
|
BCP output directed to another program ?