The text file was UTF-8 and we used CODEPAGE = 65001 and were able to process successfully.

set @Str1 = 'Select * Into ##TempPerson FROM OPENROWSET (BULK '''

set @Str2 = ''',...

We have sent a request back to the agency to get more information on the file.  What this file contains is personnel information for the supporting agency's and some agency's...

Thanks for the quick reply.  We get this file from another organization so I don't what format it is saved in other than just text.  I tried using CODEPAGE =...