Viewing 15 posts - 1 through 15 (of 23 total)
Thanks gurus... I could solve all the issuess..
April 19, 2011 at 8:13 am
by moving the OpenXML outside the transaction we could avoid deadlokc issues, so am wondering was it a only reason
September 28, 2010 at 9:38 am
A deployed report has to deal with IIS and the SSRS web
service, which adds overhead. rewite your qury to fetch parameters using SP and try
July 30, 2009 at 12:08 am
There is no way to capture RS errors if you are using SSRS report manager. On the other hand, if you are using the report viewer control, you may have...
July 30, 2009 at 12:00 am
Just changing in the dl won't help. Re-upload your rdls to new eport server and go to poperties and reassign the new data source. since SSRs, keeps repot data in...
July 29, 2009 at 11:47 pm
You can give either of the accounts. Give administrator(machinename/administrator) and password. Try to bowse from InetMgr.
Also,ceate dummy website or virtual dir under iss and put a sample html page and...
July 22, 2009 at 10:37 pm
check this url.. it wlaos works with SSRS 2005
July 21, 2009 at 3:23 am
You need to use lookup component or SQL procedue to peform this task
July 21, 2009 at 3:01 am
I don't think so there is any tool for documenting SSIS package, bout you can write a paraser to aprse dtsx and log the information what you need.
July 21, 2009 at 2:40 am
You can use Expressions to write your own script to get look and feel, we would normally make bold with underline and change color to Blue to make it look...
July 21, 2009 at 2:25 am
It is not the same. Check your IIS settings for RepotServer Virtual Directory and check whether browse option is enabled or not
July 21, 2009 at 2:10 am
Repoting Services Web logon credentials are differenct from DB engine credentials. You need to provide any user configured for Reporting SErvices. Also, check in brower-> tools->Internet options-> connections tab and...
July 21, 2009 at 2:06 am
You can also check whether Checkpoint has been enabled. If checkpoint is enabled, if the previous taks execution has resulted in error in 4th task, then it would start from...
July 21, 2009 at 2:00 am
Actually the stepname column will have the value "fail" when it has failed... So we didn't actually create additional column for the same.
Actually we got this link that helped our...
March 25, 2009 at 2:34 am
Thanks a lot for the information. We have designed the fact table as it will have following columns
Prodid
RegionId
StepId
StepName
PreviousStepName
TimeInfo (this will have time taken from prev step to current step)
CurrentTime
Hope...
March 24, 2009 at 10:46 pm
Viewing 15 posts - 1 through 15 (of 23 total)