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?
Microsoft SQL Server 2005 Enterprise Edition
November 23, 2010 7:42 PM
November 23, 2010 8:38 PM