jenlion
IS-IT--Management
- Nov 13, 2001
- 215
Have an idea floating around but no idea how to go about solving it.
Need to take transactions from a sql server database and get them into a text file. Problem is, each time we install this, the text file format needs to be different.
Thinking we could create a file that would tell our calling program how to build the text file and install that with our program. It has been suggested that we use xml and that the file that would tell the program how to output results to txt would be an xslt file.
Does this sound correct?
If so, where in the world would I start? I'm mostly a sql-server, t-sql, vb, vbs-type. Haven't had to do much xml. Looks like it's time to start taking advantage of some of this though.
How can I use xml to select database fields? How can I use this xslt to change the output?
Can anyone point me to a good tutorial and/or give me some relevant steps to pursue? Or, let me know if this is the wrong tree?
Thanks!
Need to take transactions from a sql server database and get them into a text file. Problem is, each time we install this, the text file format needs to be different.
Thinking we could create a file that would tell our calling program how to build the text file and install that with our program. It has been suggested that we use xml and that the file that would tell the program how to output results to txt would be an xslt file.
Does this sound correct?
If so, where in the world would I start? I'm mostly a sql-server, t-sql, vb, vbs-type. Haven't had to do much xml. Looks like it's time to start taking advantage of some of this though.
How can I use xml to select database fields? How can I use this xslt to change the output?
Can anyone point me to a good tutorial and/or give me some relevant steps to pursue? Or, let me know if this is the wrong tree?
Thanks!