I need help with with XML task for XSLT operation in SSIS. I have a table as below that I am generating a XML output. I give that to a XML task inside SSIS with the XSLT operation, such that the output is a well formatted HTML script. The SSIS is executing successfully, however I am not getting output as desired. The table headers appear but the table data is not present. What am I missing?
Query inside the Execute SQL Task, with the resultset as XML
The XSL program that I give as second Operand
Output I am getting
asked Dec 03, 2014 at 01:11 PM in Default
The question has been closed Mar 27, 2015 at 09:34 AM by nidheesh.r.pillai for the following reason:
The question is answered, right answer was accepted
The problem is with the XSL code. Please try this, it worked for me!!!
answered Dec 05, 2014 at 09:11 AM