Microsoft SQL Server BCP Utility password

20 pts.
Tags:
BCP Utility
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

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Redwine
    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.
    20 pointsBadges:
    report
  • Redwine
    [...] 10. Can you help a member use the SQL Server BCP utility password? [...]
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following