5

I'm having problems with importing data into a SQL Server 2008 database.

If I execute the following statement in SSMS, it works fine.

INSERT INTO 
    [dbo].[ObjectiveRatingTranslation]
( 
    [ObjectiveRatingId]
,   [TranslationId]
,   [Abbreviation]
,   [RateName]
,   [Description]
,   [CreatedBy]
,   [CreatedOn]
,   [ModifiedBy]
,   [ModifiedOn]
)
VALUES
(
    3
,   29
,   N'O / T'
,   N'På målet'
,   N'Målet har slutförts i enlighet med detta förväntningar. Uppfyller de slutprodukter som definieras. Det förväntas att de flesta mål bör vara Topplista på denna nivå.'
,   0
,   '2012-03-27T11:49:43.2300000'
,   0
,   '2012-03-27T11:49:43.2300000'
)

If I have this statement in a script file that is being executed by VS 2010, Database, Deploy. The data gets imported as

P� m�let | M�let har slutf�rts i enlighet med detta f�rv�ntningar. Uppfyller de slutprodukter som definieras. Det f�rv�ntas att de flesta m�l b�r vara Topplista p� denna niv�.

Same type of problem happens with SSIS on import to. I'm sure there must be some kind of setting that can be changed, but I"m not sure what.

Jon Seigel
  • 16,922
  • 6
  • 45
  • 85
Dwight T
  • 223
  • 1
  • 7

1 Answers1

1

The data types of the columns you are inserting the text into should be set to nvarchar.

Liam Confrey
  • 390
  • 2
  • 11