all groups > sql server dts > july 2006 >
You're in the

sql server dts

group:

Bulk Insert Task Special Characters


Bulk Insert Task Special Characters airam
7/26/2006 7:22:36 AM
sql server dts: 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 '=E1' or '=F1'. After executing the task, the corresponding
row in the database table contains symbols like '=DF' 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=EDa
Re: Bulk Insert Task Special Characters miguel.salles
7/27/2006 12:12:50 PM
Hi,

Have you tryed the -CACP command prompt option?


[quoted text, click to view]
AddThis Social Bookmark Button