Thanks, I shall go through it.

Got it solved with the below.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=104764

Problem Solved.Got my answer from

http://www.mssqltips.com/tip.asp?tip=1114

No worries I got it figured out.Thanks

You get me thinking as well, I too have a number of packages to be deployed to another server.

Does this have anything to do with the number of tables and...

Thanks a million guys!

I have a clear understanding now. I will definately give it a try....

Hi Jim,

My 1st guess would be finding out where my saved packages are being runned from? Is it FileSystem or MSDB ..Correct me if Im wrong and then deciding the...

Hi Prasad,

Thank you very much.Now it works well. I compared my webconfig file with other working servers and editted the changes.

Could you briefly explain the possible reason for this...

Hi Prasad,

It would be grateful if yu could tell me which parameter that I should change in the webconfig file.Thanks

This are my findings in the error log.Anybody out there encounter this before ?

w3wp!library!1!04/25/2008-09:33:12:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log...

Guys,

After futher investigation here is what I found, when user tries to access reports on ServerA, a pop up appears asking them to key in their user name and password.This...

Hi WWL,

I would starting by creating several dim table's[Dimension].For example

a Time Dimension Table with columns [ Time id, Month,Year, Quater...],

a Location Dimension Table with columns [Location ID, Address,City,State,Zip],Office Dimension...

This might be useful

Try this in expression

Round(21.1254045578,2)& "%"

Results is as

= 21.13%

Hopefully this is close enough for you 🙂

Chinna,

Sorry to saw Im also pretty new to scripting and am also searching for good sites and tutorial.Should keep you posted if I find any .