how to call store procedure via SSIS package

Nandhu Nand's 21 Reputation points

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,328 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
460 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Yitzhak Khabinsky 24,016 Reputation points

    Hi @Nandhu Nand's,

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

    • In OLEDB Source in a Data Flow Task.
    • In Execute SQL Task.

    Please check the following visual tutorials:

    0 comments No comments