Skip to main content
  • EN

I need to read stored procedure from SQL instead of each table. Please assist. Thanks.

I am using Microsoft SQL Server Non-spatial database.

Hi, I think you can execute a Transact-SQL EXEC statement with the SQLCreator or SQLExecutor.

If you mean a stored function (a stored procedure does not return data) you can use the SQLCreator to execute a SQL statement and use that transformer to read data into your workspace.

Reply


Community Stats

30,651
Posts
116,100
Replies
38,269
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.