Powershell - Export Stored Proc results to CSV file

*********** SQL SCRIPT TO CREATE TABLE TO HOLD FILE CONFIGURATION ***************

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE dbo.ltConfigFile(
IDint IDENTITY (1, 1) NOT NULL PRIMARY KEY,
ProcessNamevarchar(100)NOT NULL,
FilePathvarchar(500)NOT NULL,
FileNamevarchar(500)NOT NULL,
FileNameExtensionvarchar(10)NULL,
ArchivePathvarchar(500)NULL,
HeaderRow1varchar(max)NULL,
HeaderRow2varchar(max)NULL
) ON [PRIMARY]
GO

INSERT ltConfigFile
VALUES (
'ETL_TEST', 
'C:\temp\', 
'<<YYYY_MM_DD>>_TestCSVFile', 
'csv', 
'C:\temp\Completed\',
'This is a test csv file',
'Column1, Column2, Column3'
)
GO

SET ANSI_PADDING OFF
GO

*********************************************************************************


*************** POWERSHELL SCRIPT TO CREATE CSV FILE ****************************

$processName = "ETL_TEST"
$dbName = "[ENTER DB NAME HERE]"

# Get current date
[datetime] $date = Get-Date

# Get file configuration
$config = Invoke-SqlCmd -database $dbName -Query "SELECT * FROM dbo.ltConfigFile WHERE ProcessName = '$processName' "
$filePath = $config.FilePath
$fileName = $config.FileName -replace "<<YYYY_MM_DD>>", $date.ToString("yyyy_MM_dd")
$fileNameExtension = $config.FileNameExtension
$headerRow1 = $config.HeaderRow1
$headerRow2 = $config.HeaderRow2

$path = $filePath + $fileName + "." + $fileNameExtension

# Create CSV file and append header rows
$fso = new-object -comobject scripting.filesystemobject
$file = $fso.CreateTextFile($path,$true)
$file.WriteLine($headerRow1)
$file.WriteLine($headerRow2)

# Call stored procedure and append rows to CSV file
$sql = "EXEC [ENTER STORED PROC NAME HERE] "
Invoke-SqlCmd -database $dbName -Query $sql | ForEach-Object { $file.WriteLine( $_[0].ToString() + "," + $_[1].ToString() + "," + $_[2].ToString() ) }

$file.close()

*********************************************************************************