Skip to main content
Question

Not getting the ouput CSV from Run Stored Procedure - V11

  • January 10, 2023
  • 4 replies
  • 152 views
Y
Forum|alt.badge.img+4

Hi,

I am using Run Stored Procedure command to execute a SP and get the results in CSV.

However the connection and SP is working fine but the results are not populating in CSV File.

Can someone please help on this ?

Note: Connection is perfectly fine, manually SP giving the results in SQL. No additional parameters passed 

Thanks,

4 replies

C
Most Valuable Pathfinder
Forum|alt.badge.img+22
  • ChanduMohammadMost Valuable Pathfinder
  • Most Valuable Pathfinder
  • January 10, 2023

Hi @Y.Avinash 

In the SP are you returning the result value as a output parameter?

Chand
rbkadiyam
Premier Pathfinder | Tier 7
Forum|alt.badge.img+17
  • rbkadiyam
  • Premier Pathfinder | Tier 7
  • January 10, 2023

@Y.Avinash  when you run this stored procedure in console (SQLMMS), report generated and downloading ?
are you passing any path to store that csv file… ?

Ramesh B Kadiyam
S
Forum|alt.badge.img+4
  • ShivC_1
  • Navigator | Tier 3
  • January 11, 2023

You need to have a blank CSV on the path

P
Forum|alt.badge.img+1
  • prachi 4
  • Cadet | Tier 2
  • August 26, 2023

Hello all, 

I am trying to execute stored procedure using run stored procedure command and exporting the data into csv file, but data is not coming in csv file, passing correct input parameters also. 

Can anyone give assistance on this issue as soon as possible, Please? 

Terms & ConditionsCookie settingsAccessibility statement