Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Write SQL data to an XML file

Author  Topic 

TSKraemer
Starting Member

4 Posts

Posted - 2007-08-03 : 16:20:52
I need to write data returned by a stored proc to an XML file. The resultant file will then be consumed by an external application. The file has to adhere to a specific schema. Is there a way to do this through SSIS? Is .NET CLR a better option?

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-08-03 : 16:28:36
Cross post and dupe
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87348



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -