xml output

my query has this format:

SET @output=
(SELECT

FOR XML PATH(‘APSHMSA’),root(‘TABLE’),ELEMENTS,type)
select convert(varchar(max),@output) as xml

I can see the input when I click on Preview

However, when I click on the columns, I don’t see anything.

Which causes me to see this error when I click on the linked Flat File Destination

And no subsequent columns to map to.