Home Forums SQL Server 2005 SQL Server 2005 Integration Services Using Script Task to check if Folder Exists RE: Using Script Task to check if Folder Exists

  • February 5, 2009 at 1:14 pm

    #939155

    Ed (2/5/2009)

    Well... I've learned something here. You can't really disable a task at runtime. What you can do is put an expression in the workflow precedence (the arrow) to indicate whether the task following should execute. Also, if there are subsequent tasks, they will all execute regardless of the "failed" status of a preceding workflow.

    See http://blogs.conchango.com/jamiethomson/archive/2005/10/05/SSIS_3A00_-Disabled-tasks-don_2700_t-behave-as-you-would-expect_2100_.aspx

    Thanks Ed for link/help. Looks like i'll have to think of another way to work around this.