Character conversion issue in SSIS

Hi All,

I'm trying to import a ANSI format file which contains a name Portomeñe. But when I import it using the DAta flow task, it is importing as Portome�e. The special character ñ corrupting after the import. The data type of the column where I'm importing the data (whole row) is varchar(7000). Please suggest how to fix this issue. I'm in urgent need of fixing this issue.

Thanks in advance...

more ▼

asked Jul 07 at 07:49 AM in Default

avatar image

11 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I managed to import this using a csv as source and making sure the data type is Unicode string: Unicode string [DT_WSTR]. My string had a maximum of 4000 characters long.

more ▼

answered Jul 08 at 10:20 PM

avatar image

81 1 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 07 at 07:49 AM

Seen: 79 times

Last Updated: Jul 08 at 10:20 PM

Copyright 2017 Redgate Software. Privacy Policy