Thank you! that worked. you are awesome!

I'm running into the same issue for SQL Server 2016. Does anyone have a solution for this?

Doing an inventory of where SSIS & SSRS is installed, not databases.

Would it be possible to do this at the database instance level?

Thank you, much appreciated! Exactly what i was looking for.

I agree with this solution, by building a master table or a Temp table, throwing all your data in their first, than exporting to Excel. much simpler.

Great, thank you! that was it.

Great Thanks for letting me know.

Thank you! really appreciate it.

Have you tried a data conversion step?

Does anyone have a copy of the ssis package from the article?

DECLARE @XML XML

SET @XML = N'<baseEmployeeDepartmentReln>

<relationships>

<Employee>

<empId>1</empId>

<empName>Ramu</empName>

</Employee>

<Department>

<deptId>1</deptId>

<deptName>Electrical</deptName>

</Department>

</relationships>

<relationships>

<Employee>

<empId>2</empId>

<empName>Ramana</empName>

</Employee>

<Department>

<deptId>1</deptId>

<deptName>Electrical</deptName>

</Department>

</relationships>

<relationships>

<Employee>

<empId>3</empId>

<empName>Raju</empName>

</Employee>

<Department>

<deptId>2</deptId>

<deptName>InformationTechnology</deptName>

</Department>

</relationships>

</baseEmployeeDepartmentReln>'

SELECT

DV.Employee_Id

,DV.Employee_Name

, DV.Department_Id

, DV.Department_Name

FROM @XML.nodes('./baseEmployeeDepartmentReln/relationships')

AS T(relationships)

CROSS

APPLY ...

What exactly are you trying to do. Please provide a detailed description.

Thanks everyone for your responses. I really appreciate it.

tried that, but still getting same error. Thanks though.