create proc p_bcpPassword @pwd varchar(15) output WITH ENCRYPTION

as

select @spwd = 'bcppasswordhere'

return

EXEC Master..P_BcpPassword @SPwd out

select @command = 'bcp.............-P' + @spwd + '........'