Problem when executing query update

[Beatriz]

I’m trying to run an update query on sql server but an error is appearing.
I tested the connection with the data and it’s correct, can anyone help me?

[Tyler_Williams]

I think you may need to use the “Execute Non Query” activity. It also appears you have your connection improperly configured, are you able to execute a simple select query on your DB?

[Manjuts90]

@Beatriz I think u have given more properties than required, check the properties once.

[ImPratham45 (Prathamesh Patil)]

Problem when executing query update

I’m trying to run an update query on sql server but an error is appearing. I tested the connection with the data and it’s correct, can anyone help me? [immg] [immg]

can you show me the parameters

[Beatriz]

hello follows the query I’m using

USE [DB_TOP_NEXTEL_DEV]
GO
/****** Object: StoredProcedure [dbo].[SP_UPDATE_CASOENVIOBOLETO] Script Date: 24/09/2018 10:41:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[SP_UPDATE_CASOENVIOBOLETO]
(
@IDCASO nvarchar(50),
@STATUS INT

)
AS
BEGIN
Update CasoEnvioBoleto
SET
[Status] = @STATUS,
[DataAlteracao] = GETDATE()

	where Numero = @IDCASO 

END