Home > IT Answers > Development > Extracting information with a DTS package fro...
SQL Server Ask the Experts
2435 pts.
0
Q:
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?
ASKED: Aug 21 2008  3:52 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Xjlittle
265 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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
Last Answered: Aug 31 2008  1:31 AM GMT by Xjlittle   265 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0