Thanks for taking the time to read the article.

I can see linked servers doing the job as well. But I used SSIS so I could filter out the errored...

Hi,

I found the solution but you won't like the answer :).

I created a brand new report with the exact same query and properties and it worked just fine.

Thanks for the suggestion NeerajStar. But my question was more inclined towards the SSRS aspect. I wanted to know how can I create dynamic connections to the instances based on...

This issue was fixed.

Hi Guys,

I figured it out myself. The issue was due to the fact that I did not enable the User variable in the ReadOnlyVariables in the script tasks and I...

Thank you very much Jason. That is good data to get me started.

Thanks for the reply. I have not been in the market for a couple of years now and I wasn't sure of the trends in the field. Also, I wanted...

You could also use the Import export wizard to export data either to a flat file or excel sheet. This is a easier option for limited amount of data. SSIS...

Thanks Recurs1on. I will give that a try.

Thanks for the replies guys. We do not have any nightly job which would change the data during the night. I tried to do the DBCC Freeprodcache but it loaded...

If you are doing a lot of Temp table operations. You can improve performance by moving the TempDB files to a different drive and Create multiple files as oppose...

Well. I just lazy to change the formatting. But I have changed it now. To be specific, I wanted to know a way to find a way to get the...

I am storing the data in the tables however, the XML which comes in has 1000s of nodes/containers and multiple subroot elements. Therefore I decided to take 1 subroot at...

ok. Thanks for your advice. I will look into the Red Gate software

I will take a look at the data compare tool. I have heard that red gate is pretty good.