Post reply

Trigger ssis task from script task

  • March 29, 2012 at 2:35 am

    #270933

    Hello All,

    I have a ssis package that has 2 steps (1 script task and 1 ftp task). My question is how can I trigger the ftp task from with the script task (vb.net).

    what I need to if check for the existence of files and then start the ftp task if the files are there. I have written most of the code but stuck on how trigger the ftp task from with the code of the script task.

    But in general I'd like to know the basis of trigger any task in a ssis package from a script task in the same ssis package.

    Many thanks.

  • March 29, 2012 at 6:23 am

    #1466301

    I've found out that this is not actually possible, but I can acheive the same functionality by using a script task to set a variable and then using Precedence Constraint based on the value of the variable.

    Thanks

  • March 30, 2012 at 1:49 am

    #1466793

    AIRWALKER-375999 (3/29/2012)

    I've found out that this is not actually possible, but I can acheive the same functionality by using a script task to set a variable and then using Precedence Constraint based on the value of the variable.

    Thanks

    That's indeed the way to go. Thanks for posting back the solution.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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