Ive been able to translate my SQL data using TSQL and FOR XML PATH clause into XML format. Now I need to transport this XML result set into an XML file daily and upload to a FTP server.
Can I use SSIS to transport this XML result by running my query in a sproc daily to an XML file? How would I generate this XML file?
Thank you in advance.