May 28, 2009 at 8:39 am
Is it possible to publish / import a SSRS report from t-sql only?
Is there a system sp to do that?
I can't find anything on that.
May 28, 2009 at 1:42 pm
I don't knwo about using a system stored procedure, however you could look into using the rs.exe utility. http://msdn.microsoft.com/en-us/library/ms162839.aspx
It can be called from the command line so theoretically you could us xp_cmdshell. to call it from a TSQL script.
-Luke.
Edited to correct URL.
May 28, 2009 at 1:59 pm
Thanks Luke
We already use the rs.exe utility and we've come upon a case where it could be interesting to publish report from t-sql without using rs.exe.
I'm not very fond of the xm_cmdshell and I would use it only on a very very last resort option.
I've tried the profiler to catch any system calls but none were trap so either I did it wrong either it does not go by the db engine to store report files. I believe the latter is the actual scenario thus using rs.exe.
I've also google a lot and found not much about it. So I believe it's not a common scenario and not a standard way of doing it.
I'm now looking doing it in .Net instead. Not SQLCLR however.
May 28, 2009 at 2:07 pm
Should be relatively straightforward to accomplish using .Net and the WebService.
But you could also check into some of the projects like http://ssrsdeployer.codeplex.com/ from codeplex. Perhaps you could trake a look at thier code and get some ideas for your own app.
-Luke.
May 28, 2009 at 2:21 pm
Hummm the utility from the link provided seems very interesting instead of developing one from scratch.
Thks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply