How can I execute an SQL Task inside one Script Task in SSIS, both defined in the same package?

Ambros 0

Hello.

I need to execute one SQL Task defined in the same SSIS dtsx package as a Script Task is defined.

I don´t know if it´s possible to code inside the SSIS Script Task the execution of other tasks defined in its own dtsx package.

Thanks in advance for your help

1 answer

ZoeHui-MSFT 41,491 Reputation points

2023-05-17T01:54:11.45+00:00

Hi @Ambros,

Not clear about your requirement.

If you only want to run sql command in Script Task, you may take a reference here.

If you want to execute an SQL Task and Script Task together in one package, you may use the two tasks in your package.

If i misunderstand your issue, please incorrect me.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.
Please sign in to rate this answer.
Ambros 0 Reputation points

2023-05-17T06:57:12.79+00:00

Hello!

Sorry, I think I wasn´t clear.

What I need to do is execute "a" (anykind of task, p.e. ftp task or even a container of tasks which are defined in a package ) inside the c# code of an a script task "b", both "a" and "b" defined in the same package.

I don´t know what instructions should I code inside Main()

Thanks in advance for your help.

ZoeHui-MSFT 41,491 Reputation points

2023-05-18T01:30:33.2566667+00:00

Hi @Ambros,

I don't think it is possible in Script Task via SSIS.

ZoeHui-MSFT 41,491 Reputation points

2023-05-23T02:08:01.4366667+00:00

Hi @Ambros,

Do you have further question on this, could we offer more support?

If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer