So, App guys are using SSIS packages which call Bulk Load options to load the data from txt file (ANSI) to SQL Server tables.
SQL info: SQL 2005 Sp3 EE x64 (collation - SQL_Latin1_General_CP1_CI_AS)
SQL problem Column: nvarchar(150)
Issue :
Flatfile SQL Table
– changes to – -- dash changes to special character in table
• changes to • -- Bullet changes to special character in table
‘’ changes to ‘C’ -- quotes changes to special character in table
Please let me know if you have seen this before, thanks in advance!