SCRUBS for SQL Server 2008 R2 - General Interest

Nov 15, 2009 at 7:08 PM

We are currently testing the SQL Server 2008 R2  version of SCRUBS against the November CTP. We may do prereleases against the CTP released prior to RTM if there is enough interest (and we have time).

So, if you are interested pre-RTM...we want to hear from you!

Follow us & let us know! :

Add a post here and you'll be alerted by CodePlex when we supply an update.

Jul 16, 2010 at 3:04 AM

Quick news...the solution has been tested on 2008 R2.

Short answer, it works.

No major pain to get it working. For the SSRS report solution file, open up in BIDS and the first time you will be prompted for automatic upgrade. Do so, and then deploy. No changes are required for the schema or extraction logic.


Nov 9, 2010 at 4:31 PM
Edited Nov 9, 2010 at 6:53 PM

I am getting the following error when the Job in SQL Server/Agent in Run...


Client 10.0"  Hresult: 0x80004005  Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK__Reports__ReportT__2D27B809". The conflict occurred in database "SummitCloud_SCRUBS", table "dbo.ReportTypes", column 'ReportType'.".  End Error  Error: 2010-11-09 14:50:04.75     Code: 0xC0047022     Source: Reports SSIS.Pipeline     Description: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Write new Reports" (135) failed with error code 0xC0202009 while processing input "OLE DB Destination Input" (146). The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  2:50:00 PM  Finished: 2:50:04 PM  Elapsed:  3.969 seconds.  The package execution failed.  The step failed.

I am using the SCRUBS Community Edition with SQL Server 2008 R2. Any help is highly appreciated.


Apr 6, 2011 at 4:03 PM

You're right. If memory serves, there is a Report Type addd in R2. This has been corrected in the Premium Edition.

For the Community Edition, you will have to add any missing Report Types or kill the constraint.

May 19, 2011 at 11:05 PM

Any idea how it works with SSRS and SharePoint 2010 integration mode?