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
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.