If you’re curious, you can rename the .ispac file and give it a .zip extension, and extract. Voila, we see all the files that make up the ispac – a manifest, your DTSX files, and a .param file. Also note that the manifest does not have the usual uber-long .ssisDeploymentManifest extension
In order to work with report items with SQL Server Reporting Services 2008, most of the time you need to get a handle to the report items.
Here is a sample code snippet that uses the ReportingService2010 web service and PowerShell V3 CTP.
Just a short snippet to dynamically generate a database snapshot script. Could be useful especially if your database has multiple files and/or filegroups: