question

nidheesh.r.pillai avatar image
nidheesh.r.pillai asked

SSIS - Need help with XML task for XSLT operation

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? **Initial architecture-** use tempdb go create table employeelist( empid smallint identity (1,1), name varchar(10), dept varchar(10) ) go insert into employeelist (name,dept) values ('Tim','Sales') insert into employeelist (name,dept) values ('Tina','Sales') insert into employeelist (name,dept) values ('Steve','Production') insert into employeelist (name,dept) values ('Ashley','Marketing') insert into employeelist (name,dept) values ('Viola','Marketing') go **Query inside the Execute SQL Task, with the resultset as XML** select name, dept from employeelist FOR XML PATH('Row') **The XSL program that I give as second Operand** EmployeeNameDepartmentName **Output I am getting** ![Image for Output][1] [1]: /storage/temp/1823-html_op.jpg Any suggesstions?
sql-server-2008ssisxmlxslt
html_op.jpg (19.7 KiB)
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

LadyProgrammer avatar image
LadyProgrammer answered
The problem is with the XSL code. Please try this, it worked for me!!! EmployeeNameDepartmentName
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Wonderful! Thanks a lot!
0 Likes 0 ·