Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Generate XML using SSIS Expand / Collapse
Author
Message
Posted Sunday, October 14, 2012 11:01 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, December 20, 2013 4:48 AM
Points: 54, Visits: 108
Can someboy tell me is it possible to generate XML using SSIS script task and SSIS variables (not from SQL table but if not possible then ...)???
The xml which is supposed to be build has multiple nodes. eg. Parent Node->Child Node->Child Node.

I have to use SSIS variables, During Runtime the variables will be populated will data and this has to added in the xml..Any help will be highly appreciated.


thanks,
Sa.M
Post #1372519
Posted Monday, October 15, 2012 7:15 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 24, 2014 8:15 AM
Points: 52, Visits: 156
Hi,
We can generate XML files using for xml clauses in SQLServer.

Step 1: use For xml to get data into XML format.
Step 2: Assign XML data to a object variable using Execute SQL Task.
Step 3: Use a script task to generate XML file using object variable content.

Please refer to below link.

http://www.simple-talk.com/sql/learn-sql-server/the-xml-methods-in-sql-server/


Thanks,
Sambasiva
Post #1372719
Posted Thursday, October 18, 2012 1:05 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:11 AM
Points: 853, Visits: 787
what about using SQL to generate the file. Use SSIS to call the procedure.
?


Ian Cockcroft
MCITP BI Specialist
Post #1374167
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse