SQLXML/XSLT/XML - Data Export Problem
$100-250 USD
S-au achitat serviciile după ce au fost prestate
We have developed a Microsoft SQL Server 2000 stored procedure that accepts one parameter, the parameter is used within six embedded queries the resultsets
are returned as XML using FOR XML AUTO. This stored procedure is called by another stored procedure that makes use of the system stored proc SP_MAKEWEBTASK. The end result of this process is data is exported from SQL and dumped into an XML template, which sp_makewebtask turns into an XML file and stores in a directory for our clients to download.
The problem is we need to transform the XML generated by SQL into an XML structure that can be validated against our XML schema. We have already written a valid XSLT transform but we are having trouble figuring out how we can apply the XSLT to the generated XML. Embedded linking of the stylesheet is not supported in Internet Explorer. The transformation must take place before the client downloads the files or the XML will not be valid.
We are in need of an experienced, XML/XSLT guru who preferably has experience working with SQL Server 2000 and SQL XML.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.
3) Exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
Windows NT 4.0 Server
Microsoft SQL Server 2000 SP2
Microsoft IIS 4.0
Internet Explorer 6.0
ID Proiect: #3104959