Searching RDLs

As the company is moving, we needed to search for hard coded address data in all the reports. This smart individual came up with an easy way to extract all the RDLs from the reportserver database. I was especially impressed because it used bcp instead of the obtuse rs.exe. At least in SQL 2008 there was rsscripter. Anyway, once the reports are there, most any better than notepad text editor can be used to search all files in the folder for a particular string. While of course it is best to have an include or url in the report to an image, this was an easy way to get the job done.

This entry was posted in SQL, SSRS. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *