Check out this blog post from Luca Zavarelli on how to do it from PowerShell: https://towardsdatascience.com/extracting-data-from-azure-sql-server-huge-tables-in-rfc-4180-compliant-csv-files-1cb09a7a0883
Might be less heavy artillery than SSIS.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hi,
I need to store Sql query result to csv file in a given path.
I need to this task in SQL Agent.
Check out this blog post from Luca Zavarelli on how to do it from PowerShell: https://towardsdatascience.com/extracting-data-from-azure-sql-server-huge-tables-in-rfc-4180-compliant-csv-files-1cb09a7a0883
Might be less heavy artillery than SSIS.
Check it out here: https://analytics4all.org/2018/03/10/ssis-lesson-1-export-to-csv/
Hi @RAMA KRISHNA MANDALAPU
We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.