In most cases the Job owner I do not beleive would even need any access to any DB's as long as it is a valid SQL login. We use...

that is your problem then try @activityStatusID='1'

what type is @ActivityStatusID defined as?

I am not going to try to find line 97 in that but based on the error it is likely you have a subquery in the where cluase of one...

this should do the trick I would think.

case

when @ActivityStatusID = 1 then ACS.[Description] = 'Completed'

else ACS.[Description] <> 'Completed'

end

is @ActiveStatusID a parameter or a variable. and is it defined in the stored procedure. What you have look good to me other than you need to add...

we make all jobs Etc. Owned by sa. At the time of creation you simply change to owner to sa. That is all that is required.

you have a...

I sounds like you are looking for a range of dates. you would have to define a seperate parameter in the report to store the second date. set...

you need a + on both sides of the variable.

what is the error message?

you would likely what something like this.

CreateDate> '''+convert(varchar(20),@startdate)'''

you would need three single quotes so that the resulted string would include the string date in single...

In my humble oppinoin I would suggest that SSIS is likely not the best way to handle this process.

SSIS is not a file management system. While SSIS does have tools...

Before anyone could help, you need to provide additional information. Is there an error message? If so what is the error message? What are the elements of the package?...

you need to cast your dates as a varchar in order to concatenate with a string.

I would shoot as large as possible if they are going to make you predict a DB size based on such limited information. I would also clarify over and over...