This could be your problem. If the column(s) in your where clause are not the "left-most" columns in the index, then the index won't be used effectively.

For instance, if the...

Yes that was my thought...

we had the same issue 4.7 GB. the cycle procedure was renaming the archives and deleting the oldest one, but didn't touch the big file except that it would indicate...

runs fine in BIDS and when it runs normally there is a about a 10 -15 second delay between packages /job steps. After some more investigation I've seen this...

The job steps have 0 retries. Could you explain how this may help. Would a retry start the step even if it was going to run at a later time?

Also when the jobs run normally there is a short pause between steps 10 seconds or so. Now that makes me think, I should start logging pre and post validate/execute...

capturing start and end job step. Takes a couple minutes then the next step doesn't start for 20 minutes.

I have also noticed there are overlapping SSIS jobs, Is there a max concurrent jobs? for SSIS dtexec.exe?

I ended up just using a dummy script component then added a precedence constraint with the expression

This accomplished what I needed. Thanks again.

Yes, that will be perfect, thanks for the suggestion. - tom

If you copy a package it will have the same ID (guid) as the original.

After a package is copied, you should open the copied package and generate a new guid...

If you copy a package it will have the same ID (guid) as the original.

After a package is copied, you should open the copied package and generate a new guid...

A bit more info on this...

According to microsoft:

"OnPostExecute

The event handler for the OnPostExecute event. This event is raised by an executable immediately after it has finished running."

I put a message...

Also wanted to note there is nothing in the event viewer.

Thanks, I never thought of that, I am scripting the rest using the addrolemember stored procedure.