Solved

Exporting an XML record to a file

Posted on 2014-03-03
4
249 Views
Last Modified: 2016-02-10
I am looking for the best way to export a record in a table that has been saved as XML.  I have available to me SSIS.  What would be the best way to do this?  Any pointers to webpages or articles would also be very helpful to me.
0
Comment
Question by:Alyanto
  • 2
4 Comments
 
LVL 11

Expert Comment

by:Giladn
ID: 39900367
0
 
LVL 1

Author Comment

by:Alyanto
ID: 39900622
It is an export from XML to a file.
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 39902260
If it is really and Xml document saved in a column, then it should be as simple as creating an export package with a query like this:
SELECT YourXmlColumn
FROM YourTable
WHERE <add your condition here>
0
 
LVL 1

Author Closing Comment

by:Alyanto
ID: 39905816
Hi Anthony
Many thanks for this simple and effective solution.

/Aly
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

785 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question