SSIS error

Question

SSIS error

Naomi Nosonovsky 8,906

Good morning everyone,

I'm getting the following error

[Execute SQL Task] Error: Executing the query "DECLARE @ReturnCode INTEGER = 0;

[Execute SQL Task] Error: Executing the query "DECLARE @RerurnCode INTEGER = 0;

excute ? OUTPU..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

where the SQL task is defined this way: User's image

DECLARE @RerurnCode INTEGER = 0;

excute ? OUTPUT = dbo.process_incoming_facets_terminations_from_missing;

SELECT ?;

I'm not sure what is wrong with the code. The @RetunCode in defined this way:

Thanks in advance.

Viorel 126.8K Reputation points

2025-11-25T18:39:15.8766667+00:00

Is it @ReturnCode or @RerurnCode?
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T19:17:21.8133333+00:00

I just noticed at as well. Should be ReturnCode

The query is still failing with this error:

[Execute SQL Task] Error: Executing the query "DECLARE @ReturnCode INTEGER = 0;

set @RetrunCode =..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

The code definition updated two:

DECLARE @ReturnCode INTEGER = 0;

set @RetrunCode = ?;

excute ? = dbo.process_incoming_facets_terminations_from_missing;

SELECT ? as ReturnCode;

Return @Return_Code;
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T19:27:37.44+00:00

It is still failing with the same error:

DECLARE @ReturnCode INTEGER = ?;

excute ? = dbo.process_incoming_facets_terminations_from_missing;

SELECT ?;
Viorel 126.8K Reputation points

2025-11-25T20:31:36.2733333+00:00

Maybe it should just be select dbo.process_incoming_facets_terminations_from_missing()?
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T20:48:34.4+00:00

But how I return the selected value to the return result from just select? Should I set mapping of the code some other way?
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T20:53:06.79+00:00

Also, this still failed with the same error:

[Execute SQL Task] Error: Executing the query "DECLARE ? INTEGER = 0;

SET ? = ?;

select EXECU..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T21:00:20.42+00:00
This is the new code:

DECLARE ? INTEGER = 0;

SET ? = ? OUTPUT;

select ? OUTPUT = dbo.process_incoming_facets_terminations_from_missing();

--RETURN ?;w code:
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator

2026-01-06T07:28:15.4133333+00:00

Hi @Naomi Nosonovsky ,

Just to close the loop on this: the issue was caused by using SSIS parameter placeholders (?) as T-SQL variables. SSIS doesn’t support that syntax.

Once the stored procedure was executed directly and the return value was captured using ReturnValue parameter mapping (instead of DECLARE / SET / SELECT), the error was resolved.

Thanks,
Akhil.

Answer recommended by moderator

0 additional answers

Your answer

Viorel 126.8K Reputation points

2025-11-25T18:39:15.8766667+00:00

Is it @ReturnCode or @RerurnCode?
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T19:17:21.8133333+00:00

I just noticed at as well. Should be ReturnCode

The query is still failing with this error:

[Execute SQL Task] Error: Executing the query "DECLARE @ReturnCode INTEGER = 0;

set @RetrunCode =..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

The code definition updated two:

DECLARE @ReturnCode INTEGER = 0;

set @RetrunCode = ?;

excute ? = dbo.process_incoming_facets_terminations_from_missing;

SELECT ? as ReturnCode;

Return @Return_Code;
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T19:27:37.44+00:00

It is still failing with the same error:

DECLARE @ReturnCode INTEGER = ?;

excute ? = dbo.process_incoming_facets_terminations_from_missing;

SELECT ?;
Viorel 126.8K Reputation points

2025-11-25T20:31:36.2733333+00:00

Maybe it should just be select dbo.process_incoming_facets_terminations_from_missing()?
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T20:48:34.4+00:00

But how I return the selected value to the return result from just select? Should I set mapping of the code some other way?
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T20:53:06.79+00:00

Also, this still failed with the same error:

[Execute SQL Task] Error: Executing the query "DECLARE ? INTEGER = 0;

SET ? = ?;

select EXECU..." failed with the following error: "No value given for one or more required parameters.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Naomi Nosonovsky 8,906 Reputation points

2025-11-25T21:00:20.42+00:00

This is the new code:

DECLARE ? INTEGER = 0;

SET ? = ? OUTPUT;

select ? OUTPUT = dbo.process_incoming_facets_terminations_from_missing();

--RETURN ?;w code:
Akhil Gajavelly 1,570 Reputation points Microsoft External Staff Moderator

2026-01-06T07:28:15.4133333+00:00

Hi @Naomi Nosonovsky ,

Just to close the loop on this: the issue was caused by using SSIS parameter placeholders (?) as T-SQL variables. SSIS doesn’t support that syntax.

Once the stored procedure was executed directly and the return value was captured using ReturnValue parameter mapping (instead of DECLARE / SET / SELECT), the error was resolved.

Thanks,
Akhil.

Answer 1

Akhil Gajavelly 1,570 Microsoft External Staff Moderator

Hi @Naomi Nosonovsky ,

SSIS parameters cannot be used as SQL variables. Use the stored procedure return value mapping instead.

Thanks,
Akhil.

Share via

SSIS error

0 additional answers

Your answer