If you use the Excel destination in your dataflow you do not have to have Excel installed on the server.

depending on the Query structure it may have been running the plan from procedure cache rather than re process the Execution plan.

Something I have done in the past is create a copy of the report.

Change my Query in the data set to something like.

Declare @stmt varchar(max)

set @stmt='Select * from table'

Select @stmt

Then...

This would select the top UserID.

Select Top 1 t.* from

(

select Userid,count(*) as UseridCount

from mt_temp

where

UploadDate < convert (char(12),(dateadd(day,(0-(select datepart(weekday,getdate()))),getdate())))

and UploadDate > convert (char(12),(dateadd(day,((0-(select datepart(weekday,getdate())))-7),getdate())))

group by Userid

)...

I am not saying you are wrong but the fundementals of SQL dictate that it is looking for Columnname=criteria. I have never seen any variation of that. Having the...

Is it always after 1 char that you need the comma. for exmaple would it ever be

A, BC,D

Can you post some sample data? that might help determine if this can be done.

I just realized where the error is.

I am not sure how the second group or the third group could possibly work on thee own.

In the secon group you have (@Service...

This may be a silly question but did you verify that the server and the user executing the job has access to the path of the Access DB. I...

You have a permission issue to over come before you can do anything. DBO is simply a schema and does not grant you the permission to restore a database....

you talk about using the variable as the output row so I assume you are talking about using a script transform in a data flow is that correct?

If you read the previous post before I edited it I apologize I miss read your where clause to start with.

I had to copy and past it out to a...

based on what you said and based on your where clause are you intending all the statements in between the OR's to be one group?

We need a little more information to help you.

First question is how will this e-mail be sent? will this be a job that runs every day? ...

I guess I should note a distinction that may be ware the original post is catching the error as well.

If we create a brand new package then we have no...