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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!