How to create DTD compatible XML file from result set returned from a query.
Can we access FTP site and upload this xml ?
Is it possible to do from Tsql?
I suggest that you might use CLR stored procedures to accomplish what you desire. You can write C# code to extend the functionality of SQL Server and have the client call a custom stored procedure to execute that C# code. This should enable you to populate a document in any format from data stored in the server and connect over FTP to upload the file.
Hope this helps,
John
|||http://msdn2.microsoft.com/en-US/library/aa197263(SQL.80).aspx
Maybe this site can help you with witing the extended store procedure to accomplish what you want to do.
Please that DTD is deprecated , you may want to look into using XSD.
