Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Aerathi
Starting Member
14 Posts |
 Posted - 2005-10-19 : 12:27:26
|
| I was wondering if there was any way to export SQL data to xml based on the schema of an XSLT File? I have a DTS package that runs nightly, which exports data to a pipe delimited file. This file is ftp'd to another company and they (very vaguely) explained that they programatically import the data into access and that they're having problems with the seconds on the date field. They sent me a sample xslt/xml file, and instead of modifying the dts package everytime they need something changed, I was wondering if it would be possible to generate the xml file directly, instead of a pipe delimited file, based on that xslt schema. |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-10-19 : 20:45:18
|
Tell them to shove it  If they can't import a pipe delimited file they have no business being in the industry. Why should you do all the work ?(Damn I'm grumpy today  )Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
 |
|
|
|
|
|
DTS/XML