This post will teach you how to use a stored procedure in the "Tables/Queries" field in the ZappySys Export JSON/XML/CSV/EXCEL Task.
We have a store procedure in the SQL Server and want to export the data in JSON/XML/CSV/EXCEL File.
Let's configure your desired Task to execute a stored procedure and export the data in the file.
- Using ZappySys Export JSON Task we can export the data in the JSON File.
- Using ZappySys Export XML Task we can export the data in the XML File.
- Using ZappySys Export CSV Task we can export the data in the CSV File.
- Using ZappySys Export EXCEL Task we can export the data in the EXCEL File.
To use the stored procedure you must use the keyword exec (e.g. exec sp_who). We need to configure ZS Export Task like this:
Configure the Target file path location in the Target Tab.
That's it, run the package and it will execute a stored procedure and load the data in your desired file, like this we have exported the data in CSV File.
If you have more questions feel free to contact us via Live chat or email at email@example.com
Please sign in to leave a comment.