I think what the original poster is asking is whether SSRS can export to a spreadsheet and have that spreadsheet contain a drop down control that causes the desired records...

Carriage returns and line feeds together make for a standard ASCII based line ending.   Not sure if it will help, but wherever CHAR(10) appears, it probably should be CHAR(13) +...

Setting up the tables isn't necessarily difficult, but getting the design of them correct is the MOST important part.   If you can share some sample data and describe in detail...

Have you made any attempts to code this yourself?    First thing I see is that with your design, you're leaving yourself wide open to something known as SQL injection.   What...

If you were expecting this set of SSIS objects to actually merge...

What did you apply the output of the Merge to ?

If there's a problem here, it's more likely ODBC-related than anything else.   I'd check to be sure you have the latest service pack and CU for SQL Server, as well...

Try this:

CREATE TABLE dbo.DES_Nomenclator (
    ClientID int PRIMARY KEY IDENTITY,
    Info_untyped xml
);

INSERT INTO DES_Nomenclator (Info_untyped)
    VALUES    ('<?xml version="1.0" encoding="UTF-8"?>
<codeSystem>
  <codeSystemMetadata>
    <codeSystem>2.16.840.1.113883.3.3368.6.15</codeSystem>
   ...

This syntax stems from the days when CTE's didn't exist, and subqueries were painful enough, that there was at least some incentive to use it.   The idea was mostly useful...