I have an encrypted file, which I need to import into a table in my database. This file consists of the full ANSI character set, including non-printing characters. Unfortunately SSIS tries to interpret these characters by using the built-in character sets. I would like SSIS import to not interpret non-printing special characters [TAB, NULL, CR, LF, etc]. How can I get SSIS to just import every 16 characters, regardless of the content/special characters?

1. create format file

2. use following command line:

bcp.exe DBName..Table_Name in C:\Input_Filename.txt -T -f C:\FormatFile.fmt

or use SQL syntax:

BULK INSERT DBName..Table_Name FROM 'C:\Input_Filename.txt' WITH (FORMATFILE = 'C:\FormatFile.fmt')

Done.