Home > IT Answers > SQL Server > Microsoft SQL Server BCP Utility password
Redwine
20 pts.
 Microsoft SQL Server BCP Utility password
BCP Utility, BCP Utility password, SQL Jobs, SQL Server, SQL Server 2005, SQL Server 2005 Enterprise Edition, SQL Server Enterprise Edition
I am executing a Microsoft SQL Server Job that runs a BCP Utility.  The utility loads a table from a file using the 'in' argument, a format file and an error file.  I have 'hard coded' the user name and password in the command line using the 'U' and 'P' arguments.

I am looking for a method without using the 'hard coded', clear text user name and password.

Has anyone done this using the BCP utility?



Software/Hardware used:
Microsoft SQL Server 2005 Enterprise Edition
ASKED: November 23, 2010  7:42 PM
UPDATED: November 23, 2010  8:38 PM
RELATED QUESTIONS
Answer Wiki:
You can use the -T switch to use the windows account which the user is logged in with currently. If not you'll need to pass in the -U and -P parameters.
Last Wiki Answer Submitted:  November 23, 2010  8:26 pm  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Thanks Mr Denny. I left out an important piece of information from my question. This server is set a SQL Server Authentication – requires an user name and password.

Redwine
 20 pts.