Deploying Analysis Services Databases from BIDS

Once the developer is finished making changes to an Analysis Services project in Business Intelligence Development Studio (BIDS), he or she deploys the object definitions within the project to an Analysis Services instance. The deployment process, when performed through BIDS, takes place over four distinct steps: 1.       Script building 2.       Object comparison 3.       Script submission…

0

Firing a Reporting Services Subscription from an Integration Services Package

I am working with a customer who needs to trigger the subscriptions associated with a Reporting Services report just after the SSIS package responsible for refreshing the data behind the report completes its run.  Since the customer is already working with SSIS, I figured using a Script task to call the Reporting Services web service’s…

0