Extracting information with a DTS package from a database in SQL Server 2000
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
August 21, 2008 3:52 PM
UPDATED:
August 31, 2008 1:31 AM
RELATED QUESTIONS
- Export XML from SQL Server 2000
- Want to extract the Zip file using DTS Package and also run the DOSBase Batch file with it
- Error copying indexes in DTS package
- SQL Server 2000 DTS Designer components are required to edit DTS packages Error even after installing sqlserver2005_dts.msi
- How to remove specific lines from a text files using either vbs or bat.
Answer Wiki:
<a href="http://www.jitterbit.com">Jitterbit</a> 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
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
