UTF-8 Flat File

Question

Post reply

UTF-8 Flat File

vishal.kunwar

SSC-Addicted

Points: 461
More actions
December 1, 2009 at 4:12 am

#136434

Hi,
I need to copy data from Db to UTF-8 Flat File in SSIS.
Vishal

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 1

[font="Comic Sans MS"]

1) Use books online ...

2) "Please provide more information of what you are trying to achieve, with examples, and ask a question or two, obviating the need for readers to try and guess what it is that you need help with." (from Phil Parkin's post)

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

John Rowan SSC Guru Points: 56440 More actions · Answer 2

In addition to what Sabya has said, maybe try to do this yourself and let us know where you need help. We're not here to do the work for you, but to educate you so you can do the work yourself. So it's best if you make an attempt and then let us know when you are stuck and in need of help.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

vishal.kunwar SSC-Addicted Points: 461 More actions · Answer 3

hey what kind of response was that? i have asked a question whether we can genrate file in UTF-8 format or not in SSIS.

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 4

vishal.kunwar (12/1/2009)
Hi,
I need to copy data from Db to UTF-8 Flat File in SSIS.
Vishal

[font="Comic Sans MS"]

Hey - it was not a question - merely a statement as per my English grammatical knowledge!

And as per your answer - the hints are already present above. If it's not clear then RTFM ... please.

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

John Rowan SSC Guru Points: 56440 More actions · Answer 5

It was the correct answer for a question that was never asked. Based on your original post, how can we tell what you've already tried, where your problem lies, or if you are just wondering if it is possible?

The answer is yes, you can create an output from SSIS to a UTF-8 flat file.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

Phil Parkin SSC Guru Points: 246965 More actions · Answer 6

What a bizarre thread. I will watch with interest for the next informative post 🙂

Sabyasm, have you ever been accused of plagiarism? :hehe:

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

sabyasm SSCarpal Tunnel Points: 4324 More actions · Answer 7

Phil Parkin (12/2/2009)
What a bizarre thread. I will watch with interest for the next informative post 🙂
Sabyasm, have you ever been accused of plagiarism? :hehe:

[font="Comic Sans MS"]

Phil - sorry - I forgot to mention the source of those well framed phrases. After seeing this thread - was tempted to use the latest post by you ... I intended to use like "don't use SELECT * " 😛 ..

Original post edited - hope you didn't mind..

[/font]

[font="Comic Sans MS"]--
Sabya[/font]

Phil Parkin SSC Guru Points: 246965 More actions · Answer 8

Of course I don't mind mate - spread the word!

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

mbeckman 66233 Grasshopper Points: 11 More actions · Answer 9

Brand new to the forum, trying to resolve a problem for task I inherited from departed colleague. I am not a sql expert, or a developer. But my problem seems to be close to this one: SSIS package queries sql database and formats a properly formed xml file exported to a file share. XML file needs to be in UTF-8 format. I've updated the flat file connection manager, General ..code page from ansi-Latin 1 to 65001 - UTF-8.

Updated Advanced...datatype from String [TD_STR] to string [DT_STR]. With these updates the package produces an empty xml file. With only the first change, I receive a helpful error but I don't know how to troubleshoot it. The error is:

"Error at data flow task [Destination-Client.xml[19]. The code page on input column "Series" (26) is 1252 and is required to be 65001." It fails validation.

When I edit "DataFlow Path Editor", in Metadata I see a column for Data_Type. It is set to DT_STR. This is what I think needs to change to 65001 but I can't figure out how to edit it. (I copied to clipboard the following):

"Name""Data Type""Precision""Scale""Length""Code Page""Sort Key Position""Comparison Flags""Source Component"

"Series""DT_STR""0""0""8000""1252""0""""Source - Query"

Thanks in advance for your assistance.

kramaswamy SSCoach Points: 18181 More actions · Answer 10

You should usually start a new thread, instead of continuing a two year old one 😛

Try throwing in a data conversion step, and convert your column through that. Near the end of the line you'll see the codepage, and you should be able to change it to 65001 through that approach.