Ah, I see what you're doing. You are using the OnError and OnTaskFailed handlers for the same task. Let me explain the difference between the two event handlers.

When...

prasannabe06 (3/11/2009)

---

Hi Aaron Akin,

I have read your article about "Using EventHandlers with Checkpoints". It is very usefull for me. But OnError eventhandler is not executing for the second time even...

gary.proctor (2/19/2009)

---

Hi Aaron

Yeah, I feel kinda stupid now. The object did have an expression set on that property. It was changing the value as soon as the expression was evaluated....

kgiambas (2/19/2009)

---

Hmm...I have to disagree with you on this. Though your alternative (assign the CheckpointFileName to a variable and use a package config to change the variable) works just...

I thought of this as well, but you cannot set the CheckpointFileName property with package configurations. You'd have to add a variable and create an expression that would set...

Hi Gary,

1. Is there an expression at the package level that is setting the value of the CheckpointFileName property. This would cause any changes to this property to be...

Excellent. Can't imagine how I missed that. Thanks!

It's great that you got it to work properly. I'd be interested in the details. I tried every way possible (or so I thought) but never had any...

Thanks for the info. I will look into it.

As for using/not using identities...do you recommend staying away from identities? If so, why?

-Aaron

By the way...

I know this all sounds like a pretty poor system, and I would have to agree.

This company has had tremendous growth lately, and have never had a real...

The structure of the databases are identical, and the biggest problems is with the dev database. It is never fully refreshed from production. When a developer needs the...