Creating datasource on server from *.rds file

Hello
I would like to create a datasource (using the rs.exe utility and the actual
*.rds file) in the same way reports (*.rdl) can be created, as described in
this link
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_9n79.asp. I
know you can create a datasource using CreateDataSource method, though I
want to be able to have the report files (*.rdl) in one folder and the
associated datasources (*.rds) in another and have the script automatically
pick up these files (GetFiles() etc.) and create them on the report server.
This will prevent the script from needing changing again...
I have also tried CreateResource, though that merely creates an rds file on
the server.
Does anyone know whether this is possible?
Thanks,
MarkYes, this is totally possible with the script host and the scripting
utility. You will have to set your reference to the shared data source for
your report after you upload the rdl files.
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"MCC" <cmc_za@.hotmail.com> wrote in message
news:uVGMNPUeEHA.2532@.TK2MSFTNGP09.phx.gbl...
> Hello
> I would like to create a datasource (using the rs.exe utility and the
actual
> *.rds file) in the same way reports (*.rdl) can be created, as described
in
> this link
>
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_ref_soapapi_service_ak_9n79.asp. I
> know you can create a datasource using CreateDataSource method, though I
> want to be able to have the report files (*.rdl) in one folder and the
> associated datasources (*.rds) in another and have the script
automatically
> pick up these files (GetFiles() etc.) and create them on the report
server.
> This will prevent the script from needing changing again...
> I have also tried CreateResource, though that merely creates an rds file
on
> the server.
> Does anyone know whether this is possible?
> Thanks,
> Mark
>
>