• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 288
  • Last Modified:

SQL 2005 - Data export to xml file

Hello,

I am trying to provide a monthly feed to someone from data a SQL table.  is there a way to export to an xml file?
0
Hollie18502
Asked:
Hollie18502
1 Solution
 
Forefront_Data_SolutionsCommented:
Here are some examples for using bcp to export to XML files:
http://msdn.microsoft.com/en-us/library/ms191184.aspx

I know that you can also use SSIS to export to XML files, so you might try doing an internet search for examples.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now