connection string for xml file in ssrs

we receive XML files, before adding them into OLTP database, we want to check contents.

I was thinking that it would be very fast to develop some reports in SSRS; and, it really was, i had them ready in no time

BUT, all was done on one file

i want to change connection string so that people can enter the file name

found some info but everythng i tried (like URL="http://localhost/"&Parameters.Filename.Value&".xml" ) fails at runtime with following message:

An error has occurred during report processing. (rsProcessingAborted)
- Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand)
  - Failed to prepare web request for the specified URL. (rsXmlDataProviderError)
    - Invalid URI: The URI scheme is not valid.

Typing simple filespec like http://localhost/test.xml seems the only thng that works

All help is very welcome

Answer this question

connection string for xml file in ssrs

ennisb

geertdeprez wrote:

we receive XML files, before adding them into OLTP database, we want to check contents.

I was thinking that it would be very fast to develop some reports in SSRS; and, it really was, i had them ready in no time

BUT, all was done on one file

i want to change connection string so that people can enter the file name

found some info but everythng i tried (like URL="http://localhost/"&Parameters.Filename.Value&".xml" ) fails at runtime with following message:

An error has occurred during report processing. (rsProcessingAborted)

Query execution failed for data set 'DataSet1'. (rsErrorExecutingCommand)

Failed to prepare web request for the specified URL. (rsXmlDataProviderError)

Invalid URI: The URI scheme is not valid.

Typing simple filespec like http://localhost/test.xml seems the only thng that works

All help is very welcome

seems not very popular, sill does not work though

connection string for xml file in ssrs

Answer this question