FOR XML PATH Query results to file with SSIS
Posted
by whimsql
on Stack Overflow
See other posts from Stack Overflow
or by whimsql
Published on 2010-04-29T16:08:29Z
Indexed on
2010/04/29
16:57 UTC
Read the original article
Hit count: 263
In SSMS I've gotten my for xml path query written and it's beautiful.
I put it in an "Execute SQL Task" in the Control Flow, set the resultset to XML.
Now how to I get the results into an actual xml file that I can turn around and FTP to a third party?
This should have been so easy! I would put the XML into a variable but we are looking at a HUGE file, possibly 100mb+
Do I need to use a Script Task? (I'd like to avoid that if there is another option.)
© Stack Overflow or respective owner
