I need to read stored procedure from SQL instead of each table. Please assist. Thanks.
Hi, I think you can execute a Transact-SQL EXEC statement with the SQLCreator or SQLExecutor.
+18- Contributor
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.