Generate XML using SSIS

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Generate XML using SSIS

Generate XML using SSIS

Rate Topic

Display Mode

Topic Options

Author

Message

Sam....

Posted Sunday, October 14, 2012 11:01 AM

SSC Rookie

Group: General Forum Members
Last Login: Monday, May 13, 2013 1:24 PM
Points: 49, Visits: 96

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

samba.sesham

Posted Monday, October 15, 2012 7:15 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 2:17 AM
Points: 52, Visits: 150

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

Ian C0ckcroft

Posted Thursday, October 18, 2012 1:05 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 23, 2013 6:48 AM
Points: 841, Visits: 732

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 »

Permissions