HI
Wiring up the Execute Stored Procedure running against on-premises SQL Server should be easy once you sort out the SQL Execute permissions for your test user.
ALTER PROCEDURE [dbo].[usp_GetHappiness]
(
@YourParam nvarchar(128)
However, we found that type SYSNAME aka nvarchar(128) which are Unicode parameters , is not supported - you get this nice error. Where is this documented in https://docs.microsoft.com/en-us/connectors/sql/#general-known-issues-and-limitations
Database functions with non-scalar parameters aren't supported.
inner exception: Database functions with non-scalar parameters aren't supported.
In SSMS we created a new stored procedure with the following parameter
ALTER PROCEDURE [dbo].[usp_GetMoreHappiness]
(
@YourParam varchar(25)
This worked perfectly. We did try editing the old sp definition but the old param type definition persisted, as did the issue with the flow .
Related issue
