Well, it looks to me like you have not taken into account your requirement for the Month-1 logic. To produce the results you've shown with your sample data, it...

So what would you expect the results to be with your sample data? Which rows do you want the query to return?

Like Gail said, you'll have to wait it out.

Gail,

I too was wondering if the instance was already restarted, but not sure if recovery was being confused with ROLLBACK status...

So given the sample data you've provided, what would your expected result set look like?

What data type are your tables using for ref_date? Is it integer as shown (bad practice) or datetime?

The only way to stop it from continuing is to shut down SQL Server. I would strongly advise against this. The recovery is performing the necessary steps to...

Permissions for anyone accessing these files directly for modification would be handled at the file system level. There is no audit. The system security plan should document the...

It is a little unclear what you are asking for. I see you are new to SSC as well. Please read through the article in my signature line....

I assume then that you have your send mail task set up in the OnError event handler? That would work as well.

Well, I would typically use a JOIN for this, but it's realy hard to give you any advice when we have no idea how these tables are related.

Can...

What data type is User::RUN_STATUS?

From BOL:

Requires INSERT and ADMINISTER BULK OPERATIONS permissions. Additionally, ALTER TABLE permission is required if one or more of the following is true:

Constraints exist and the CHECK_CONSTRAINTS option is not...

Your code works fine for me. That is, if I change the DB names to be actual names in my SQL instance and fix the typo in your second...

Instead using a script task prior to your For Each Loop Container, here's what I'd do:

1. Create a package level variable called FileCount (type int).

2. Add a step...

SELECT SUM(CASE WHEN RequiredCompletionDays - NumberOfDays < 0 THEN 1 ELSE 0 END) as NegativeVarianceCount

FROM ........