Sorry about that. You need to add an alias to the end of the subquery.

SELECT ESO_PORT,

SUM(Ontime_s) Ontime_s,

...

I believe this will work for you.

SELECT ESO_PORT,

SUM(Ontime_s) Ontime_s,

SUM(Late_s) Late_s,

SUM(Ontime_c) Ontime_c,

SUM(Late_c) Late_c

FROM (SELECT

ESO_PORT,

case when ONTIME_S = 'On Time' then 1 else 0 end as Ontime_s,

case when ONTIME_S = 'Late' then...

Jamie Thompson wrote a blog post several years back on this:

http://consultingblogs.emc.com/jamiethomson/archive/2006/11/19/SSIS_3A00_-Using-temporary-tables.aspx

Any chance you could open the .rdl file in BIDS? You should get something more descriptive than #Error in the BIDS error list.

Without an error message it's hard to say but a quick guess is that you are trying to sum different data types. Since amount is probably a decimal type,...

From: http://technet.microsoft.com/en-us/library/cc785078%28WS.10%29.aspx

Computer accounts and domain assignment for cluster nodes

Make sure that the cluster nodes all have computer accounts in the same domain. Cluster nodes cannot be in a workgroup.

Before removing the order by, make sure that the SSIS package output is not sorted. You will probably be better off to leave the sort in the query instead...

You need to make sure that all of the values returned by the case expression are of the same data type. It appears that you are mixing a datetime...

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

;WITH Observations (ObservationIndex, MRN, PainScale, DateTimeDocumented) AS

(SELECT ROW_NUMBER() OVER (PARTITION BY CV.IDCode ORDER BY OD.RecordedDtm) AS ObservationIndex,

CV.IDCode,

SOBS.value,

OD.recordeddtm

FROM CV3ClientDocument CD

INNER JOIN CV3ClientVisit CV ON CD.ClientGUID =...

Try replacing your two scalar functions

dbo.GetFinancialYear

dbo.GetDepositCategory

with the SQL equivalent.

Typically you'll need to publish to ReportServer ($ instance name if not on the default instance) and not Reports. To verify the URL open the Reporting Services Configuration manager...

You can get this information from by joining sys.views to sys.columns

What I would like...

It happens to me all the time. I use this:

DECLARE @VIEW_CURSOR AS CURSOR

DECLARE @VIEW_NAME AS VARCHAR(1000)

DECLARE @STR_SQL AS VARCHAR(2000)

SET @VIEW_CURSOR = CURSOR LOCAL STATIC FOR (SELECT name...

Try starting the service in single user mode by running  sqlservr -m or changing the options in EM.  If you can get connected you should be able to...

Your SP should be wrapped in a transaction if it's updating data in a table.  Why would this be a bad thing?