You may also use the Script task and a .Net library to accomplish this...

Why not make an SSRS report with a data driven subscription?

Mike,

Can you post your entire query? If all you are looking up is the EmpID why do you need a query to define it? If you want it to return...

Perhaps this user is in a different network location that is preventing the access?

Go buy the Kimball groups book 'The Microsoft Data Warehouse Toolkit'. It contains all that you seek...

Depending on the urgency of the need you could possibly wait until you upgrade to SQL 2008 which includes the Dundas charts as part of SSRS...

Is the challenge that:

1. There are there multiple sheets that need to be consolidated?

2. The sheets are in different formats (eg. columns in different order)?

You're not understanding my suggestion...

Use 'Remote Desktop' or whatever app you have to remotely login to servers and login to the report server itself. If you don't have that setup...

I mean log into the report server itself and go to the Report Manager and run the report. This is where you'll see the more descript errors. Also, If it's...

It sounds like you're still missing a fact table...what in your design is being aggregated? I tend to approach these challenges by looking at all my data points independently and...

Hmm...is it an option to run the report from the report server itself? When you enabled remote errors did you restart the SQL Reporting Services Service as well as IIS...

If the lowest level of granularity is per day I would suggest incorporating this logic to aggregate the hours by day into your ETL process. No need to store the...

Is that the only message you received? Usually when I see that there is also something like 'Stored procedure doesn't exit or is not found...'

By order it is layed out do you mean that you have precedence constraints between your control/data flow tasks and it is running them in a different order than that?

Try adding some row count variables and determing what the SSIS package is seeing vs. what the SQL Agent job might be reporting. This should help you determine if the...