adisql - Monday, October 16, 2017 9:38 PM
This no problem in SSIS ... a basic package.
You'll need a data flow with an OLEDB source (which executes your query & collects the results) and a flat file destination (whose format you will define as you create the package).
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.