Do you have the SQL Server OLEDB drivers installed on the XP machine? You said that you were able to connect via SSMS from XP, so we know that...

Try http://www.msbiacademy.com/ and http://pragmaticworks.com/. But I just have to ask, how in the world do you get a job in BI with no database experience?!?

MWise

What is the load on your production server? If there is capacity you could always create a reporting db on the same instance and use SSIS to move data...

I found my work around. Basically you use a datasource in the main report to hold the header values you need, in my case it was just the ReportName,...

Page headers/footers will not show up when the report is used as a subreport. You can try to use table headers in the subreports. But then there is...

I would either execute the .NET code that Lowell provided in a SSIS script task. In a prior position I used to do work like this via an MsAccess...

Do all of the reports actually get used and how much? For the ones with less usage, why don't you set the external data to refresh on open. ...

For a data driven query you'll need a source query/table/view that contains the email addresses and the parameters to supply to the subscription. The wizard pretty much walks you...

You shouldn't have any problem accessing databases on 2005 from 2008 R2 reports. I would recommend upgrading your reports to 2008 R2. There were lots of improvements from...

Try this: http://msdn.microsoft.com/en-us/library/ms345522.aspx#_FAQ30

MWise

If you roll your own subscription service using SSIS to access your SSRS reports and send the email via T-SQL or SSIS component you can specify which mail profile to...

We run the process on the server that logs are located on and write them into our db server which is a different server. Check the documentation on how...

I used Brian Larson's "Delivering Business Intelligence" for SQL Server 2005. It was servicable and covered the basics, but I would have preferred it use AdventureWorks for it's sample...

What are you trying to learn in SSAS? Most of the general BI books will be SSIS/SSAS/SSRS combos and you'll walk through building a data mart in SSIS, cube...

If you only need a subset of tables and need that data transformed into Dimension and Fact tables, I'd recommend using SSIS to perform the ETL tasks.

MWise