format 파일 이용하시면 될것 같습니다.

cat a
1|"ABC"



bcp tempdb..test in a -Usa

Enter the file storage type of field a [int]: enter
Enter prefix-length of field a [0]: enter
Enter field terminator [none]: enter

Enter the file storage type of field b [char]: enter
Enter prefix-length of field b [0]: 1
Enter length of field b [10]: enter
Enter field terminator [none]: "

Do you want to save this format information in a file? [Y/n] y

Host filename [bcp.fmt]:

Starting copy...

1 rows copied.
Clock Time (ms.): total = 4  Avg = 4 (250.00 rows per sec.)