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