[Visual Studio Extension Of The Day] BIDS Helper

A Visual Studio.Net add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio (BIDS).

Features

• Analysis Services
  • Aggregation Manager
  • Calculation Helpers
  • Column Usage Reports
  • Delete Unused Aggregations
  • Deploy Aggregation Designs
  • Deploy MDX Script
  • Dimension Data Type Discrepancy Check
  • Dimension Health Check
  • Dimension Optimization Report
  • Duplicate Role
  • Many-to-Many Matrix Compression
  • Measure Group Health Check
  • Non-Default Properties Report
  • Parent-Child Dimension Naturalizer
  • Printer Friendly Aggregations
  • Printer Friendly Dimension Usage
  • Roles Report
  • Similar Aggregations
  • Smart Diff
  • Show Extra Properties
  • Sync Descriptions
  • Test Aggregation Performance
  • Tri-State Perspectives
  • Update Estimated Counts
  • Validate Aggregations
  • Visualize Attribute Lattice
• Integration Services
  • Batch Property Update
  • Biml Package Generator
  • Create Fixed Width Columns
  • Deploy SSIS Packages
  • Design Warnings
  • dtsConfig File Formatter
  • Expression and Configuration Highlighter
  • Expression List
  • Fix Relative Paths
  • Non-Default Properties Report
  • Pipeline Component Performance Breakdown
  • Reset GUIDs
  • Smart Diff
  • Sort Project Files
  • Sortable Package Properties Report
  • SSIS Performance Visualization
  • Variables Window Extensions
• Reporting Services
  • Dataset Usage Reports
  • Delete Dataset Cache Files
  • Smart Diff
• General
  • Enable/Disable features
  • Preferences
  • Version Notification

Download it from Visual Studio Extension Manager