SSIS error

Question

SSIS error

Naomi Nosonovsky 8,881

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 125.6K Reputation points

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

Is it @ReturnCode or @RerurnCode?
Naomi Nosonovsky 8,881 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,881 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 125.6K 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,881 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,881 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,881 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 875 Reputation points Microsoft External Staff Moderator

2025-11-26T05:43:51.6533333+00:00

Hi @Naomi Nosonovsky ,

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

Thanks,
Akhil.

Your answer

Viorel 125.6K Reputation points

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

Is it @ReturnCode or @RerurnCode?
Naomi Nosonovsky 8,881 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,881 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 125.6K 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,881 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,881 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,881 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 875 Reputation points Microsoft External Staff Moderator

2025-11-26T05:43:51.6533333+00:00

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

Your answer