dbTalk Databases Forums  

Persist SSIS vaiable as XML document

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Persist SSIS vaiable as XML document in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default Persist SSIS vaiable as XML document - 06-14-2006 , 03:55 PM






Here is what I am trying to do:
I build an xml document by running a couple SQL tasks and store the
nested XML document into variables.
I assemble them using a script task.
The XML is now a valid XML document containing all my recursive XML
elements.

I now want to persist this as a physical XML file on the file system.

Is there a way to do this without using the old filesystemobject?

TIA


Reply With Quote
  #2  
Old   
Michael Entin [MS]
 
Posts: n/a

Default Re: Persist SSIS vaiable as XML document - 06-15-2006 , 03:38 AM






You can use System.IO classes in the script task.

Regards,
Michael.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

<emailwaste (AT) gmail (DOT) com> wrote

Quote:
Here is what I am trying to do:
I build an xml document by running a couple SQL tasks and store the
nested XML document into variables.
I assemble them using a script task.
The XML is now a valid XML document containing all my recursive XML
elements.

I now want to persist this as a physical XML file on the file system.

Is there a way to do this without using the old filesystemobject?

TIA

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.