Thank you for your response.

Yes. I am referring to Drill Through. The spreas sheet will be hosted in a sharepoint. This spreadsheet will be used by different business groups....

Hi ,

thank you for your response. I had a 3 month old back up and I restored the resport server database in...

Hi All,

thank you all for your responses. The issue is resolved. It is because I used...

Thank you for your response. I tried the same and I got this error.

OLE DB provider "SQLNCLI" for linked server "(null)" returned message "Login timeout expired".

OLE DB provider "SQLNCLI" for...

Hi,

You are right. Say for example I have a solution with 2 packages. The first one pulls data from XL to SQL Server database and the second one pulls data...

Thank you all for your answers.

I think I should set up a dev environment same as the one which is in Prod. I would like to know which deployment method...

Exactly...I am presently using XMLA file deployment. But it requires a lot of documentation explaining the connection changes. The DSV, everything would be different in the prod environment.

Hello...Thank you for your reply...Anyways I do not know what is BIDS.

Actually the KB article did not help. It says a higher version of the patch already exists. I refferred several articles. Most of them say something about Keebros integration with...

Thank you all for your responses. I think the issue was statistics and the volume of data. I was thinking any thing within 10000 should perform the same way with...

Thank you for the reply.

In my case the dataset are really small.

Hello,

this works. I can manage to use temp tables.

Thank you,

Ashok Jebaraj

Hello Thank you for your replies,

here is the sample data. The spread sheet contains the expected results also.

Thank you,

Ashok Jebaraj

Thank you for the response.

Now say you have a clustered index in a table called Customers with CustID as PK. Does seek and scan on Customers table start from the...