Do you have SSIS installed on other pc's with latest services packs? So not just the SQL client like Management Studio but the actual SQL server Integration services.

To be honest it is something I picked up from other developers and thought that was the right way to do it which is obviously not. :crazy:

I ran the...

Why don't you just run the SELECT/SP from the data flow source?

So use a OLE DB Source Connection, change the Data access mode to SQL command and ad your SELECT...

Just to let you, incase some else has a similar performance issue, I have solved this by moving the query filters out from the WITH MEMBER clause and built into...

I had the same problem this week, also had a script that called a SP a few times. After running the script and trying to close it the window 'There...

Make sure the deployment settings of your Report Project are correct. Check that your TargetServerURL is: "http://ServerName/ReportServer" and NOT http://ServerName/Reports".

If that still does not work check your...

Carl, I did exactly as you said, and I can see the improvement. I now have a Clustered Index on ValuationPoint, ValuationPointDate and ValidationExceptionId in that ordered and I have...

That makes sense! Let me give it a go. Thanks to all for your input. 🙂

The only transactions that happen on this table are inserts and the selects for the reports.

I have attached the table def, it has the Clustered Index which is on the...

The tables has about 40 Columns, I have 14 reports that all expect the 3 WHERE clause conditions, the only difference are the columns that are returned, so I would...

Paresh, you have to create the appropriate index that will cause a Index Seek. So First test without the Non clustered index which results in a Clustered Index scan, then...

Thanks for your help, I will check the tme and reads! 🙂

One way of doing this is by select Report Properties from the Report menu, view the Layout tab and change the Page Width and Height. The default should be A4...

I have done this before in Reporting Services and I remember using a hidden textbox to store the value that I needed, trying to figure it out now again as...

Remove the DateAdd from the WHILE

while @datetime1 <= @datetime2