Thanks Koen it worked. I was not sure if I was able to connect the different control flow. Thought I would get some type of error.

a4apple thanks for the link.

I needed to add select (...) as COL_XML that did the trick.

Thanks everyone for your help.

Brandie when I took out he Binary Base64 I still get the same funny character on the XML output file.

Brandie here is a screen shot that you requested.

I was changing the datatype to see if I get a different output when I run the package. Currently when I run it with DT_NTEXT and that is the only...

There is no error msg. The package runs just not getting the output that I'm suppose to get. I am getting funny looking characters.

yes I refresh the flat file destination metadata

attach is a screen shot

Error msg say " The data type for input column "Copy of XML_f52e2b61-18a1"(330)" is DT_NTEXT.

When I change encoding to unicode and the data type DT_NTEXT to that this is what...

Here is a screen shot of the error, not sure if this will work.

In connection Manager the encoding is Unicode

right now there is no error because I have the data type set as Unicode text stream [DT_NTEXT]

Sorry Brandie, I did not make myself clear enough. I can change the data type but the problem is when I do change it to anything beside Unicode text...

Here is the query that I am using

SELECT DISTINCT TOP 10

PLastName

,PFirstName

,PBorough

,PState

,PZip5

,PIdentificationType

,PIssuedBy

,SCity

,SState

,InspectionDate

,InspectionTime

FROM vwECB

FOR XML RAW('MOV')

,ROOT('ECBXML')

,elements

,BINARY BASE64;

The Hierarchy design is correct as far as I can see.

The Data type is the same in the connection manager and in the Data Conversion Transformation Editior.

I'm looking for a...