If you have Office packages you must run the SSIS x86 that is 32bits directory to execute your code because there is no 64bits Office driver. I can help...

Asp.net does not use UDL or DNS it uses integrated security or SQL permissions like the code below, what you are looking for is very old data access.

Data Source=INSTANCENAME;Initial Catalog=AdventureWorksLT2008;Integrated...

You seem to be stuck on the fact I am including multiple tables and graphs on the same report and several of these components need a separate query to pull...

There is an option with XP_CMDSHELL with proxy account, check below for details.

http://msdn.microsoft.com/en-us/library/aa260700.aspx

My reason is even in 2006 Vista technically does not support VS2003 so now you are on your own. Check below and please read the last comment which I...

That is the answer I was expecting on four stored procedures because it is the amount of data profiler produces that makes it not for production so you need to...

My reply was based on the OP needs which I recieved in PM. I was letting the user know in 2008 there is no valid reason to start new...

When you have four queries you have two choices either convert it to views or use subreports, that is do design before wrting code so your code will run.

You need to read up on the restrictions for image in header and footer to get to know why styles and SSRS which is data display tool are not related....

If your stored procedure is not running it means someone is writing very bad code because SSRS usually run stored procedure more than SELECT statement because it passes execution to...

SSRS designer is full of bugs and not fluid so if you don't want to use custom assembly your options are limited and I think you need to know RDL...

I use both Asp.net and SSRS so I think both comes with different development tools so Asp.net is more flexible, however here are two articles that will help with how...

Actually for SQL Server 2005 and up VS2003 is too old you may not get any help from Microsoft if you need...

It helps if you have Visual Studio 2008 any for pay edition like standard or professional then you can use both OLE DB and ADO.NET with the new Entity framework....

You could try Management Studio Express with SP3 if you still did not see the SAC and Configuration manager then you may need to remove the current Express and install...