Automate deployment of reporting project

I have to deploy reports several times a day [to our teesting environment]
due to contstant changes by devlopers. Does anyone know of a way to automate
the deployment process? Even doing something with VBA will work. I don't
see any possible references listed in the VBA references section - would the
createobject method work? Has anyone does this? I would love to get this on
a schedule and off my plate.
Thanks in advance,
John Hennesey
p.s. Third party programs are an option too, if anyone knows of any.You should be able to do all you need with a bit of scripting and the rs
utility. The following link should give you an idea, based on the reporting
services sample reports:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_1apd.asp
"JohnHennesey" wrote:
> I have to deploy reports several times a day [to our teesting environment]
> due to contstant changes by devlopers. Does anyone know of a way to automate
> the deployment process? Even doing something with VBA will work. I don't
> see any possible references listed in the VBA references section - would the
> createobject method work? Has anyone does this? I would love to get this on
> a schedule and off my plate.
> Thanks in advance,
> John Hennesey
> p.s. Third party programs are an option too, if anyone knows of any.|||Thank you for your response. This will do the trick, will take a bit of
massaging to get it to where I want it to be. Ideally if I could use the
Visual Sourcesafe object model to pull down the latest code, then use a .Net
object model to open the solution, change the deployment path then deploy it
would be ideal.
But, I can use command line script to pull down the latest code base from
SS, then iterate through the file list (.rdl's only) via the Scripting engine
and deploy from there.
Thanks for your help!
John
"David Jennaway" wrote:
> You should be able to do all you need with a bit of scripting and the rs
> utility. The following link should give you an idea, based on the reporting
> services sample reports:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSAMPLES/htm/rss_sampleapps_v1_1apd.asp
> "JohnHennesey" wrote:
> > I have to deploy reports several times a day [to our teesting environment]
> > due to contstant changes by devlopers. Does anyone know of a way to automate
> > the deployment process? Even doing something with VBA will work. I don't
> > see any possible references listed in the VBA references section - would the
> > createobject method work? Has anyone does this? I would love to get this on
> > a schedule and off my plate.
> >
> > Thanks in advance,
> > John Hennesey
> >
> > p.s. Third party programs are an option too, if anyone knows of any.