Re: import unicode flat file

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 07/28/04


Date: Wed, 28 Jul 2004 20:09:27 +0100

In the properties of the Text File data source is a drop down entitled "File
Type". In there you will find unicode

-- 
-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know
"Dean" <noreply@fakeaddress.com> wrote in message
news:ce8s2n$mee$1@news01.intel.com...
> Is is possible to import a unicode flat file? I'm using a Text File
(Source)
> connection object, with a Transformation Data Task to a table. But an 8 KB
> file shows up as 3 characters of gibberish. The destination column is
> nvarchar(4000). Does the Text File connection support unicode?
>
>
> -- 
> Disclaimer: This post is solely an individual opinion and does not speak
on
> behalf of any organization.
>
>


Relevant Pages

  • Re: import unicode flat file
    ... > In the properties of the Text File data source is a drop down entitled ... Duh, ... The file can be either ANSI or UNICODE. ... Or is there some way to convert ANSI files to UNICODE? ...
    (microsoft.public.sqlserver.dts)
  • Re: import unicode flat file
    ... Allan Mitchell MCSE,MCDBA, ... www.SQLDTS.com - The site for all your DTS needs. ... The file can be either ANSI or UNICODE. ... Or is there some way to convert ANSI files to UNICODE? ...
    (microsoft.public.sqlserver.dts)