I add ExecuteNonQuery activity as picture below.
I set Sql as code and picture below.
UPDATE [dbo].[Calendar] SET [Active] = 0 WHERE [CalendarID] IN (@CalendarID)
First scenario, I have one CalendarID and set Parameters as picture below. It’s work, updated column in database.
Second scenario, I have two CalendarID and set Parameters as picture below. It’s not work.
Could someone please help to suggest me?