Thank Grant. I will try your suggestion. Just wanted to make sure I' doing it in a correct way.

Karen A. Ferrara-426245 (2/18/2014)

---

I understand -- If you add the event handler to just the package failure tab and set all your tasks to FailParentOnFailure = false and FailPackageonFailure =...

Well!! I guess template will not work for me. Let me try to rephrase my requirement.

My ssis pkg contains many task (on the avg 20 task) and for each task...

Even I'm doing the same thing. The only difference is I'm using sepate pkg to write my logging logic & calling it inside event handlers.

My actual question was, is there...

I tried running it with DTEXEC utility. Still the same output.

Its seems from your statement that there is some problem with columns mapping. Can you share some portion of your excel (if possible) so that I can see why you...

What data source are you using ? Could suggest a solution only if you can give me some idea of this.

Agreed with CozyRoc.There should not be any problem with installing the patch. What I personally think behind alien behavior for your SSIS is that there must be some problem with...

If the succeeding task is not getting fired that simply means there is some problem with your precedence constraint. Crosscheck your precedence constraint.

Attach your package image (just to have...

Well, I am also working on a scenario very similar to yours where we dont have any primary key defined for our datawarehouse table but we have to incremental load...

Are you doing this in Execute SQL Task ?? If yes then this is not the correct eway to assign value to the variable. If no then give a bit...

let me know if it's not resolving your problem..

Hey,

Just gone through the Excel that you have posted. Your getting NULL which is obvious in your case. Its's behaviour of MS SSIS engine.

SSIS engine, by defauly, scans 1st 8...

Grant Fritchey (5/17/2011)

---

Without a transaction, a rollback of a delete statement requires you to have already stored the data elsewhere. If you really need complete recovery and you're working within...

You're right but that's not possible in my case. The scenario is, I had created Autosys jobs which calls and execute DTS package(s) which...