Monthly Archives: May 2012

What’s Inside an SSIS 2012 .ispac File?

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


Get a Report Handle Using SSRS2008 and PowerShell V3

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.

Read more