Hi,

I do not understand the idea behind exporting that output to a Comma Separated Values file type, I will not look behind this requirement, I will just provide you with the answer.

I suppose you are running a SSIS Package using DTEXEC, when running applications from the command line you can redirect the stdout stream to a file.

e.g. C:\DTEXEC -f test.dtsx > C:\folder\output.csv

This will create the output.csv file under the C:\folder folder containing all the information what would appear if you have run the application as you were doing it.

In my opinion, this would be the easiest approach to what you are trying to achieve - no PoSh required.