Respond to bcp Prompts

Unless you supplied bcp with the -P parameter, it prompts you for your password when you copy data in or out using the -n (native format) or -c (character format) parameters.

If you do not supply either the -n, -c or -f formatfile parameter, bcp prompts you for information for each field in the table or view.