Post reply

SSIS packages - Optimizing execution time

  • April 18, 2006 at 10:38 am

    #114276

    Hi,

    Is it possible to suppress the validation of packages every time it runs? Can the packages be set to prevalidated mode so that during runtime, it only executes and not validates since validation takes about 40% of the time?

    Thanks in advance

    Srividya

  • April 18, 2006 at 2:58 pm

    #632968

    Use the DelayValidation property to...well...delay validation.

    If this property is set to false then the container it is scoped to will be evaluated when the package starts up and when the container starts to execute.

    If this property is set to true then the container it is scoped to will only be evaluated when the container starts to execute.

    -Jamie

     

    Jamie Thomson
    http://sqlblog.com/blogs/jamie_thomson

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply