Home > IT Answers > Development > Extracting information with a DTS package fro...
Help

Question

Asked:
Asked By:
Aug 21 2008   3:52 PM GMT
SQL Server Ask the Experts   2275 pts.

Extracting information with a DTS package from a database in SQL Server 2000


XML, SQL Server 2000, DTS packages

We currently use a DTS package to extract data from the database and export it in either an XLS file or a TXT file. We now need to be able to export it as an XML file, and SQL Server 2000 DTS functions do not appear to support this directly. How do you recommend we proceed?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: Aug 31 2008  1:31 AM GMT  by Xjlittle   265 pts.




Jitterbit may be able to help you. It is an open source middle ware product that can pull data from a given source, including SQL, and export it to another source such as XML, text and so on. Give it a try and see if it work for you.

hth
-j
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and SQL Server.

Looking for relevant Development Whitepapers? Visit the SearchWinDevelopment.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register