is there any possibility to get the result of a stored procedure from a SQL Server through the new db nodes? I read through older postings, but could not find anything that solved my problem.
Nevertheless it works with the legacy Database Reader node with the option checked “Run SQL query only during execute, skips configure”.
I am trying this on SQL Server 2014 which works fine in SQL Server Management Studio:
EXEC [BSRPPDBSVPDWH_USER].[dbo].[procReportPace] @Start = N'2021-04-07', @End = N'2021-04-07', @Time = 6
I am getting the following error: Incorrect syntax near the keyword ‘EXEC’
Thank you and kind regards,