So if we created a an OLE DB Source with this SQL
select field_1, field_2, field_3
from table_1 For XML AUTO
It would create xml results from the TABLE then send the data to a RAW file
Destination, But the file is not valid because it is missing
<?xml version="1.0" encoding="ISO8859-1" ?> at the beginning of the file.

Why is there not an XML Destination in SSIS?

Is there a better way to create XML file using SSIS?

Thanks

Mike