Today I use DTS to export to .txt files i different ways. That works great,
but now they want it out on XML format. Is there anyway I can use DTS for
this or do I need to go trough my VB code to do this.
Depend on what bersion you are using. In SQL 2000 you can do it using For XML statement indicated by Anith
and of course you can write scripts to do it as well
David Wang MCSD MCAD MCSE MCDBA
This posting is provided "AS IS" with no warranties,and confers no rights.
Subscribe at http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nos...
1. The Windows Ansi format problems with our spesial characters. I am
putting the result in a file an looking at it in NotePad gives me strange
characters. In edit mode in dos or on the screen directly it looks fine as
2. How to get rid of headers an lots of blanks after the file.
When I use QA and puts the result out to a file it look very nice indeed.
It is strange that you cannot use a data transformation tast i DTS to put a
FOR XML result into a file directly.
I will try some other ideas I have.
Thank you for the help.
> Today I use DTS to export to .txt files i different ways. That works
> but now they want it out on XML format. Is there anyway I can use DTS for
> this or do I need to go trough my VB code to do this.
> Any ideas?
> Thanx all
I need to import an XML file(s) into SQL Server, and
subsequently export data in an xml format from SQL
Server. I tried using the DTS import/export text file
facility, but was very surprised that there weren't any
options for an xml formatted text file. Am I missing
something? I find it nearly impossible to believe that
SQL Server 2000 doesn't have a native means of importing
and exporting from/to an xml formatted file. Can anyone
suggest a means of accomplishing my objective?
I'm running SQL Server 2000 on Windows XP.