Run SQL Stored Procedure with parameter in Alteryx

[lumjingbki]

Hi am trying to execute a SQL Stored Procedure from Input tool. After I set up the connection I am able to see the SP and its parameters, Data type and value in the "Stored Procedures" tab. I am int data type as parameter. When I run or test connection I get error stating "No columns returned".

Please note:

- I have tried executing the same SP with parameters in SQL studio and am getting the data as required.

- I have checked and my connection is correctly mapped in Alteryx as I am able to query tables from alteryx using select statement

- I have also tried giving ' ' single quotes in the parameter (as per a youtube learning)

can someone please help

[jmartinezb]

Hi @lumjingbki,
Can you provide screenshots of the "Stored Procedures" tab, "SQL Editor" tab and some more information about the error?

Thks.

[lumjingbki]

@jmartinezb am unable to share the screen shot. can you let me know what details or checks I can perform in the "Stored Procedures" tab, "SQL Editor" tab. 

[jmartinezb]

hi, @lumjingbki 

I asked you for screenshots to be able to identify the problem.

Anyway, I think you have a problem with the definition of the connection to the DB (setup).
As I show below, it depends on the connection what you can or cannot see in the query configuration tabs, and the error you are receiving when you run the flow.

I hope this guides you and you can solve the problem by trying different connection providers: SQLncli, ODBC, OLEDB.

[lumjingbki · Accepted solution]

@jmartinezb  Hi thanks for the details. I had my connection on ODBC and followed this article for solution.

https://knowledge.alteryx.com/index/s/article/No-Columns-Returned-for-Stored-Procedure

[Namshad]

Hi @lumjingbki ,

Could you please describe the method you have used ?