SSIS Execute SQL Task Editor and Parameter Mapping Order

Question

So I have an Execute SQL Task Editor Task that executes a SQL Server Stored Procedure with 26 Parameters and forgot one...and it's about half-way down the list of 26.

Is there any way that I can add a Parameter into a specific position within the Execute SQL Task Editor Parameter Mapping? Or do I have to Remove all the subsequent Parameters and Re-Add in at the spot in which the Parameter is missing?

Thanks for your review and am hopeful for a reply.

Answer 1

Hi @Bobby P ,

It depends on what connection type the SSIS Execute SQL Task is using.

Check it out here: SSIS "Execute SQL Task" - stored procedure with input parameters

As you can see, the ADO.NET is using named parameters instead of numbers. It means that their sequential position is irrelevant, they are not position based.

Answer 2

Hi @Bobby P ,

Check execute-sql-task about the parameter names and markers in Execute SQL Task.

Also you may refer below about calling Stored Procedure in execute sql task in SSIS.

https://bageshkumarbagi-msbi.blogspot.com/2019/11/call-stored-procedure-in-execute-sql.html

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.