Another SSIS Package Validation Question

We are going to be running a package repeatedly 24/7. The same package against the same data store, filtered using a "stageFlag" so as not to read rows previously processed. We have various timing statistics and have yet to fine tune; but on the surface it appears that it takes approximately three minutes to validate and another three minutes to run. If we have no additional data on the second run it still takes three minutes to complete - to do nothing but skip rows already processed.

Is it possible to set this up to run repeatedly without the validation on each iteration

Any ideas as to how this would be accomplished would be greatly appreciated.

Answer this question

Another SSIS Package Validation Question

Avikash Nadan

Hi Jamie,

Setting DelayValidation to false does cause an extra validation to occur because we always validate right before we execute but if delay validation is false then we also validate it up front. You might wonder why we do this since it does slow package execution. The answer is so we catch problems before the package runs for a long time. If you had a package that took 8 hours to run then it would be very useful to catch the error in the first validation pass than to wait until 7 hours had passed before getting to the task that would fail validation, but we give the option to turn it off as needed.

Matt
Douglas Drury
Have you already set DelayValidation = True on the appropriate tasks Also, you might try running Profiler to see if it is being executed twice.
Karol Duzinkiewicz

No this is not possible. We always validate before an execution because the package doesn't "know" that nothing has been changed externally.

Matt
miker55

David,

Try setting DelayValidation=TRUE.

-Jamie
Graz
Dear Matt,

I also have a problem about Pre-Execution Phase that it takes very long time. (Some packages have been taken around 2 minutes, but some is less, and some package could not start execute phase, so I disable it)

Could I have any solution to solve this

Thank you very much for your help

Nop
Sam Vella

Matt,

A small question. If DelayValidation=FALSE will a task get validated twice. i.e. once at package startup and once immediately prior to the task firing Or is it one or the other

I only ask because I'm sure I've seen situations where setting DelayValidation=TRUE on a task causes the whole package to run quicker. Perhaps I was mistaken...

Thanks

Jamie
Leon Finker
I thought this only delayed validation until later - that it still had to be validated before execution. I want it to validate once and then run forever. I will check it out again; but if you've understood my request and could respond that would be great.
Michou Prévost
Let's keep this thread alive please!

We also have validation-related problem. We have a package, which calls a very large stored procedure. The procedure is complex, it uses temp tables and takes 1.5 hours to execute. The entire process runs 1.5 hours in DTS, but twice as long (3.5 hours) in SSIS. I suspect that the validation phase actually executes the stored procedure, which is why the overall execution takes so long.

Any suggestions on how we can resolve this

Thank you!
Another SSIS Package Validation Question

Answer this question