Post reply

SSIS parameters validation

  • November 2, 2010 at 9:10 am

    #142323

    Hi Guys,

    Here I am stuck with Date Validation.I have StartDate and EndDate parameters in MY PACKAGE. I need validate these dates before it enters the data flow....I have some specific start end end dates...it should allow to go to the data flow only when dates between those RANGE else it should be directed to E-mail task....

    Pls let me know if you have any ideas.....

    Thankyou

    Preensheen

  • November 2, 2010 at 9:13 am

    #1245477

    Take a look at using expressions with precedence constraints.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • November 11, 2010 at 2:02 am

    #1249324

    You could do it with a script task or even an exec SQL task. Script task might be easier..

    CEWII

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

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