Hello,

I have a Bulk Insert Task to load records from one text file to a SQL
Server database table.

My problem occurs when the input text file has some special characters
like 'á' or 'ñ'. After executing the task, the corresponding
row in the database table contains symbols like 'ß' instead of the
original characters.

It doesn't work defining the field as varchar or nvarchar.

I imagine the problem can be in the options of the Bulk Insert Task
(Code Page, Data file type,...) but I don't know how to configure it
to make it works.

Any help will be appreciated.

Thanks in advance.

María

Hi,

Have you tryed the -CACP command prompt option?


airam wrote: