Hi @gangadhar ,
Thank you so much for posting here.
SQL Server supports bulk exporting data from a SQL Server table by using below methods:
- bcp utility
- SQL Server Import and Export Wizard
You could also use SQL Server Reporting Services (SSRS) or SQL Server Integration Services (SSIS) in SQL Server Data Tools (SSDT) within Visual Studio.
Please refer detailed steps in below links and check whether any of them is helpful to you.
How to export SQL Server data to a CSV file
Using SQL Server Integration Services to Export Data in JSON Format
Best regards
Melissa
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues November--What can I do if my transaction log is full?
Hot issues November--How to convert Profiler trace into a SQL Server table