How to use stored procedures with SSIS packages ?

Hi Ajit,

Find the following steps:

1. Open the Integrated Service Project (SSIS) in Visual Studio

2. Open the SSIS Toolbox option in the window

3. Drag and Drop the "Execute SQL Task" on the .dtsx page
4. Double click on the SQL task

5. You can see the "SQL Statement" from the "SQL Statement" menu.

6. Click on the file open icon

7. Set your procedure name.

8. Then click ok.

Follow the below URL for your reference: We have copied record from table to file, you set the table instead of text file.

https://www.c-sharpcorner.com/article/load-data-from-database-to-text-file-using-ssis-package/

I hope this helps.