Home > IT Answers > SQL Server > encryting output file from BCP
jswayne1964
5 pts.
 encryting output file from BCP
BCP Utility, encrypt files
I am exporting data using BCP util, in SQL native format, creating an output format. The proces executes a stored procedure, creating a temporary table, and then the BCP exports the table to an output file, in native SQL. Is there a method to have this output file encrypted without a 3rd party process?

Software/Hardware used:
ASKED: December 7, 2012  4:17 PM
RELATED QUESTIONS
Answer Wiki:
Encrypted File Service or EFS ? I do not think BCP has any way to encrypt the data that it is pulling out of a table. I think you will have to use a third party tool in order to encrypt the file that you have created with the BCP operation.
Last Wiki Answer Submitted:  February 5, 2013  10:12 pm  by  Colin Smith   845 pts.
All Answer Wiki Contributors:  Colin Smith   845 pts. , jftamames   30 pts. , jswayne1964   5 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _