I need to read stored procedure from SQL instead of each table. Please assist. Thanks.
I am using Microsoft SQL Server Non-spatial database.
Userlevel 2
+17
- Contributor
- 7538 replies
-
9 February 2016
Hi, I think you can execute a Transact-SQL EXEC statement with the SQLCreator or SQLExecutor.
Userlevel 2
+12
- Contributor
- 2177 replies
-
9 February 2016
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.