Sql express

SSIS and Import/Export
,
1

Hi,
My requirement is need to export query result to csv file in a folder automatically
where if I run stored procedure it will give query result then it need to automatically export to csv with timestamp. Using Microsoft sql server management studio.

I have tried unable export the result in CSV automatically.
Please help to sort out this

2

This is normally done with:
Powershell - https://www.sqlservercentral.com/articles/exporting-data-with-powershell
BCP - https://www.red-gate.com/simple-talk/sql/database-administration/creating-csv-files-using-bcp-and-stored-procedures/
SSIS
etc

1 Like