DECLARE @Table Table(

Machine varchar(10)

,Set_speed int

,Actual_speed int

)

INSERT @Table VALUES

('Loft', 1000, 450),

('Loft', 1000, 335),

('Loft', 1000, 120),

('Loft', 1000, 140),

('Loft', 1000, 750)

GO

SELECT TOP 5 Machine,

Count(actual_speed) MachineCount

FROM @Table

WHERE Actual_speed < set_speed - 500

GROUP...

Are you talking about Report Navigation at URL?

I guress there is no problem in installation. You can't create any objects in Analysis Services DB directly. However you can execute XMLA scripts to create SSAS Objects.

To answer your...

You can use UserID parameter which will store DOMAIN\UserID. Now get UserID from this parameter value and use SWITCH expression in Group Hierachy as per requirement.

If the input is delimitted string then you can use below function

Function to Split Multi-valued Parameters

I guess you are looking for report navigation. Right click on the supporter field --> Navigation --> Jump to report --> Select same report.

Now set the parameters values same as...

I guess you should use Script Task and Log the values of variables in the code. That way you can see the values in SSIS log table (SQL Server 2005...

Did you set all the options correctly?

here is the link:

http://msdn.microsoft.com/en-us/library/ms187653.aspx

Just to confirm, do you have only one variable User::RecCount or multiple variables with same name and different scope - one for Execute SQL Task and another for Package? If...

I have had faced similar issue few weeks back. I did following things to resolve the issue:

1. Open i-explorer with Run as administrator and go to http://reportserver/reports

2. click on Home...

OK. CozyRoc is best solution 🙂 But I didn't mentioned codeplex as a best solution against CozyRoc since I never tried. I wrote in general way.

I am sorry if...

There is reason why codeplex is best solution: We need to specify...

Best way to load SharePoint Lists into SQL Server table is to use codeplex solution SharePointListAdaptersSetup.msi

Click here to downloaded this.

After running this msi, two SSIS Data Flow controls SharePoint...

Suppose you are running a Data Flow Task in a For Loop control or ForEach Loop control. There may be a case when you want to use ConnectionManger1 for some...

only4mithunc (6/10/2010)

---

Can you try using matrix ?

1)Drag the first column to the first column of the matrix

2)Insert one row for the column data and drag the second row record....