Udostępnij za pośrednictwem

BIDS Helper, RS Scripter

  • Artykuł

I wanted to point out two Reporting Services utilities built by our MVPs and user community that you may find very useful.

BIDS Helper is a CodePlex project: https://www.codeplex.com/bidshelper

In past releases, the focus has been on significantly enhancing Analysis Services and Integration Services BIDS design experiences.  Version 1.4 was just released, and for the first time BIDS Helper now also includes small Report Designer enhancements:
- identifying unused datasets in the report (by removing them you may speed up your report)
- deleting dataset cache files (.rdl.data) directly from within BIDS

RS Scripter is a utility for scripting and managing report server catalog items: https://www.sqldbatips.com/showarticle.asp?ID=62

You might find RS Scripter particularly useful for:
- quickly and easily extracting all RDLs from a report server
- generating scripts to load reports, data sources
- script shared schedules, subscriptions, system and item level roles
- migrating contents from one report server to another