Reading XML File -- sql server reporting services

Shlomi
7/21/2007 10:02:01 AM

Hello,
I'm trying to read data from xml file (i want to use this file as
enviornment config file). i tried 2 methods and failed in both of them:
1.a. I loaded the XML file to the report server
1.b. I wrote a custom code for reading the XML. i got #Error

2.a. I loaded the XML file to the report server
2.b. I used XML dataset for reading the XML file.

thank you all

EMartinez
7/22/2007 1:30:28 AM

[quoted text, click to view]

If you are using SQL Server 2005, you might try importing the XML file
into a table via an SSIS/Integration Services package (that can be
called from the same stored procedure that is sourcing the report).
Then you can access the table the same as any other table. You might
just need to pay attention to the security required for executing the
SSIS package. Hope this helps.

Regards,

Enrique Martinez
Sr. Software Consultant

sql server reporting services : Reading XML File