The most recent script posted no longer contains a CASE statement, so I cannot use it to address your question.

I have returned to your original posting to try...

There may be an inconsistency between your text description any your SQL query: The text description has " if ELAPSED days is > 60 AND COUNT >=4 then 1 else...

Good thought, but the time was good, and both systems were synching with the same time server

That was another strange thing, SQL server log did not show any attempt to connect, but the firewall said the attempt was getting through. We never DID determine what...

Try setting DELAY VALIDATION to TRUE, that may allow your package to complete the steps up through table creation, and look for the table when it needs the table, not...

I would be VERY tempted to create multiple stored procedures, one as a "parent", and one for each of the possible combinations of the @flag variables.

Call the parent passing in...

I would be tempted to do this a little differently. I am not certain what the efficiency impact would be, but it seems to be easier to see what...

So far I have not been able to resolve this directly. I have found that if the WITH GRANT OPTION is granted to an individual acount as opposed to...

From a completely different angle, the more SPs there are in the DB, the more places there are to determine and manage security and rights, and the more chances trhere...

try this:

After storing the package created by the wizard, open it directly in BIDS. Make sure that configuratios are enabled, that the correct connections are being stored in the...

Alan and ssismaddi, thank you as well for your assistance.

The table involved is new, having been created specifically and exclusively for this process, so there are no other processes that...

Thanks for your ideas.

The table is not being deleted at any point in the process, nor has it been accessed by any other processes at this time; I...

The solution I used for a similar issue required that the detail rows contain a header number. In your sample data, it looks like the header row number is the...