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 |
|
bryan42
Starting Member
28 Posts |
 Posted - 2007-07-19 : 08:51:42
|
| I need to redirect the output of a stored procedure so it's the input for a DOS utility that encrypts the output and produces an encrypted file. A requirement here is to not have the unencrypted output written to a file. This is in a DTS, though calling the stored procedure from outside the DTS would be fine.I just found BCP. Could that be used to output to stdout? Another idea was to use activeX/VB to capture the output of the stored procedure and redirect it to the utility. I've never used BCP or VB, so some ideas and recommendations here would be much appreciated.thanks,Bryan |
|
|
|
|
|
Question about redirecting output