SQL Server changes - to –

• SQLRocker

  SSCrazy

  Points: 2217

  More actions

  July 6, 2012 at 5:37 pm

  #392685

  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!

• SQLRocker

  SSCrazy

  Points: 2217

  More actions

  July 9, 2012 at 2:13 pm

  #1510570

  Anyone?