how to call store procedure via SSIS package

Question

Nandhu Nand's 21

I want to trigger a store procedure via SSIS package

i have one store procedure once I run a package i want directly that procedure execution

some one help me

thanks in advance

Nandhu Nand's 21 Reputation points

2023-05-01T13:07:43.2766667+00:00

I'm new to SSIS
AniyaTang-MSFT 11,561 Reputation points Microsoft Vendor

2023-05-02T05:50:07.61+00:00

Hi @Nandhu Nand's

I think Yitzhak's answer is very useful, please check if the following link helped you.

If the answer is helpful, please click Accept Answer and Up-Vote for the same so that people with similar questions can find answers quickly. If you have any questions, please feel free to let us know.

Best regards,

Aniya

Nandhu Nand's 21 Reputation points

2023-05-01T13:07:43.2766667+00:00

I'm new to SSIS
AniyaTang-MSFT 11,561 Reputation points Microsoft Vendor

2023-05-02T05:50:07.61+00:00

Hi @Nandhu Nand's

I think Yitzhak's answer is very useful, please check if the following link helped you.

If the answer is helpful, please click Accept Answer and Up-Vote for the same so that people with similar questions can find answers quickly. If you have any questions, please feel free to let us know.

Best regards,

Aniya

Answer 1

Usually, stored procedures are called in SSIS via the following two methods:

Please check the following visual tutorials:

Use Stored Procedure in OLE DB Source in SSIS
https://www.youtube.com/watch?v=0oyQhvib2EU
How to call stored procedure with parameters in SSIS
https://www.youtube.com/watch?v=MAQgFu8TuCk

1 answer