New Version of SSRS add-in released for SharePoint 2010

July 28, 2012 in Uncategorized

Today a new download showed up on my RSS feeds and I wanted to take a minute to compare this new MSI file against the trusty old MSI I’ve used for so long now.   As you know, the SharePoint 2010 Prerequisites installer requires “rsSharePoint.msi” to be loaded before you can install SharePoint 2010.   Below is the OLD link for SSRS which most people use today for cool stuff like a PowerShell script to download all Prerequisites for offline install. as well as the NEW link.   The release of Service Pack 2 for SQL 2008 R2 seems to be triggering lots of new downloads so it might be worthwhile to make sure you’re SharePoint front end binaries match the backend SQL server version.   If patching SQL to SP2, then it’s probably a good idea to update the web front end components and look for the “4000” version number.

 

NEW –
SP2
http://www.microsoft.com/en-us/download/details.aspx?id=622 10.50.4000.0 7/27/2012 36.9 MB
OLD –
SP1
http://www.microsoft.com/en-us/download/details.aspx?id=28132 10.50.2500.00 11/3/2011 36.9 MB

 

It might be a good idea to download the most recent add-in for any new server installs.  There appear to be updates to most all files, but “sqlserverspatial.dll” grew more than most possibly hinting at better geographic data support.

 

image

 

Old Package – File Version Detail

image

 

New Package – File Version Detail

image

 

.program filescommon filesmicrosoft sharedweb server extensions14templateadminreportserverreportserverproperties.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templateadminreportserverreportserversitesettings.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverrsaction.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverrsintegrationresults.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverrsviewerpage.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserversitelevelsettings.aspx
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1025sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1026sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1027sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1028sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1029sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1030sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1031sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1032sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1033sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1035sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1036sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1037sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1038sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1040sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1041sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1042sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1043sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1044sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1045sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1046sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1048sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1049sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1050sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1051sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1053sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1054sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1055sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1058sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1060sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1061sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1062sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1063sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles1087sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles2052sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles2070sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles2074sqlrvdefault.css
.program filescommon filesmicrosoft sharedweb server extensions14templatelayoutsreportserverstyles3082sqlrvdefault.css
.program filesmicrosoft sql server100keyfile1033rssharepoint_keyfile.dll
.windowsgacmicrosoft.reportingservices.sharepoint.ui.serverpages.dll
.windowsgacmicrosoft.reportingservices.sharepoint.ui.webparts.dll
.windowsgacmicrosoft.sqlserver.types.dll
.windowsgacrssharepointsoapproxy.dll
.windowsgac_32microsoft.sqlserver.types.dll
.windowssystem32sqlserverspatial.dll
.windowssyswow64sqlserverspatial.dll

EmptyList.ps1 – delete all SharePoint list items with PowerShell

March 21, 2012 in Uncategorized

Recently I needed to empty an InfoPath Form Library by deleting all of the items and skipping Recycle Bin.  Datasheet view is great for small lists (a few hundred rows) but it doesn’t perform as well on large lists.  Also, skipping the Recycle Bin is a unique requirement best handled with server side code.  See the below PowerShell script for how to easily “empty” any SharePoint list or library.  This works with both SharePoint 2010 and SharePoint 2007 (MOSS 2007).  NOTE – Use this script carefully, it is really good at deleting.  Smile

 

[System.reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
 
$site = Get-SPSite "http://sitename/"
$web = $site.rootweb
$list = $web.Lists["Shared Documents"]
$caml=""
#optional filter
#<Where><Eq><FieldRef Name=""ContentType"" /><Value Type=""Text"">Form</Value></Eq></Where>"
 
$query=new-object Microsoft.SharePoint.SPQuery
$query.ViewAttributes = "Scope='Recursive'"
$query.Query=$caml
 
$items=$list.GetItems($query)
Write-Host $items.Count

$items | % { $list.GetItemById($_.Id).Delete() }
 
$web.Dispose()
$site.Dispose()

Add-SPSolution: Failed to extract the cab file in the solution (FIXED)

August 20, 2011 in Uncategorized

Today I saw this error message and was able to fix by renaming the original source files in Visual Studio 2010 to remove special characters.   After checking on Google it appears that symbols such as ~!@#$%^&* may cause issues.   Lesson learned: keep file names simple so SharePoint is happy.  Smile

Add-SPSolution: Failed to extract the cab file in the solution.

8-3-2011 8-44-21 AM

References

Return to Top ▲Return to Top ▲