How to call Store Procedure on Import connection Type

[Nyan]

Hi Experts,

We are using SQL Database and configured import connection with SAC. We want to use store procedure which are created in SQL Database. But on import connection freehand query, we only can get data table and create select sql statement.

Is there any other way to use store procedure or a query with parameters?

Thanks in advance!

BR,

Nyan

[TuncayKaraca]

Hi Nyan,

I doubt SAC import SQL Database (I think you meant Microsoft SQL Server) connection supports calling Stored Procedures. The nature of SAC connections should be read-only mode but data manipulation statements can be used in the stored procedures.

One thing you may need, maybe you should grant EXECUTE permission of your Database User. Check the database user's permissions, and try!