kbnyny (4/16/2014)

---

I have created a SSIS package to generate an XML output file. The package run without any errors. The problem I am having is when I go to open the XML file it has all these crazy looking characters instead of the data that it should have.

In my Data Flow I am using a OLE DB Source with sql command. The script run fine, returning the data that I'm looking for when I run it in a query.

I have a Data Conversion for the input column and output alias with data type unicode text stream [DT_NText]. When I try and change the data type to anything else I get the red x on the flat file destination.

I am using a flat file destinations, mapping is correct.

I am not sure what is wrong. Can someone please help me out.

Thank you,

Kevin