I have three task in my SSIS package,1. Script Task2. Execute Process Task3. FTP Task I want to enable disable Execute Process Task and FTP Task on runtime using script task, How to do that?Do we have any property of dts using which we can access property of other task iin script task like Dts.Connection("Connectionname") for Connection Controls?

Questions by Dhara3011   answers by Dhara3011

Showing Answers 1 - 3 of 3 Answers

gnanagopal

  • Jun 19th, 2008
 

Hi Dhara,


1. create a variable
2. assign value for variable in the script task.
3. Use expression to enable or disable the taks based on the variable values.

let me know if you have any more details.


cheers,
gnanam.

  Was this answer useful?  Yes

shreeprakashr

  • Dec 11th, 2008
 

Hi,

In this case, We can disable the script task at the run time but we cannot disable succeeding tasks based on the variable. I tried and got to know this. Please correct me if i am wrong.

Regards
Shree

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions