Post reply

Can we enable or disable particualar "Execute SQL Task" ?

  • April 24, 2014 at 8:16 am

    #307073

    Hi All

    I have created a package to track the log of SysSsisLog table into another table. I have used the stored procedure to maintain the log. What I want is to enable or disable this sql task from another task by passing parameter 0- LOG, 1- NO LOG. Can it be possible?

    Please let me know if there is any work around. Thanks in advance 🙂

    Regards,

    Nikhil

  • April 24, 2014 at 8:20 am

    #1708419

    You can use precedence constraints in SSIS and have an expression over it to do this.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

  • April 24, 2014 at 11:43 am

    #1708535

    Thank you 🙂

    Can it be possible for particular task./package?

  • April 24, 2014 at 12:21 pm

    #1708548

    Nikku (4/24/2014)

    Thank you 🙂

    Can it be possible for particular task./package?

    Yes. You might want to review this article by Andy Leonard from the Stairways series on SSIS. It discusses how to set up variables and use expressions in precedence constraints.

    Advanced SSIS Workflow Management – Level 8 of the Stairway to Integration Services[/url]

    Edit: Correct a misspelling

  • April 25, 2014 at 12:54 am

    #1708676

    Thank you Sir 🙂 it helps me a lot.

Viewing 5 posts - 1 through 4 (of 4 total)

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