Are you issuing a series of INSERT statements or are you using something like an OLE DB Destination from SSIS? If the former, then check the N prefix mentioned earlier. If you are using the latter, could you please post a sample file (you can attach it as a text file to this thread) and confirm the version of SSIS you are using? I would be curious to try and recreate the issue on this side.