Azure SQL Data Factory Copy Activity with Sink Stored Procedure

I cant get this going and seem not to find solutions on this forum. I am new to Azure

I have successfully established a direct SQL Query copy activity from on Prem SQL Server to Azure SQL.

When I proceed to edit to include a Stored Procedure it fails. I have created a data type and stored procedure as follows in the Azure Sql;

CREATE TYPE [dbo].[Patch] AS TABLE(      [BaseKey] int,      [GISKey] [varchar](10),      [ActiveFrom] datetime  )  DROP PROC IF EXISTS dbo.spCopyPatch  GO  CREATE PROC dbo.spCopyPatch  @Patch dbo.Patch READONLY,  @BaseKey int,  @GISKey varchar(10),  @ActiveFrom datetime  AS  INSERT INTO dbo.Patch( BaseKey,GISKey,ActiveFrom)  VALUES(@BaseKey,@GISKey,@ActiveFrom);  GO  

I then proceeded to edit the copy activity Sink. It is able to pick up the Stored Procedure OK;

However this fails on debug: Am I getting it right or missing something?

Your help highly appreciated in advance.

https://stackoverflow.com/questions/66558253/azure-sql-data-factory-copy-activity-with-sink-stored-procedure March 10, 2021 at 12:10PM