Using SSRS to update/inject data

Question

Using SSRS to update/inject data

Paul Morris-1011726

SSCommitted

Points: 1879
More actions
January 3, 2012 at 10:56 am

#254277

Has anyone done or tried to use Reporting Services to update or inject data to a table? Should I avoid this?
I currently have to manually edit the table and wanted to move away from that...
What permissions are used to write to the table if I am deploying the reports 'vanilla'?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 1

It is possible. I do it in a few situations. One thing to beware is putting redundant data into your db, you should definitely check for that. I would recommend using an SP rather than an inline query and set your SP permissions appropriately for your environment.

Paul Morris-1011726 SSCommitted Points: 1879 More actions · Answer 2

Thanks for the reply...

one questions though, if a deply this for a user, does the update happen using that person rights or the rights of the admin who deployed?

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

I've done it to save default parameters (for each user).

I've done it to mark rows as processed or ignored or printed.

That's about as far as I'm willing to go. SSRS is supposed to work much like a function... read only.