PowerShell - Run SQL Query save file to network specify output file name

Question

Simple task that I am hoping Power shell can be used.
Each day run a SQL query and save csv file to a network folder.

This works:
invoke-sqlcmd -ServerInstance DESKTOP-HG7ATKK\GP2018 -Database FARGO -query "Select * from IV00101" `
| Export-Csv -Delimiter "|" -Path "C:\SQL\export.csv" -NoTypeInformation

I need to modify so that the 'exports.csv' file created is formatted a specific format.

Format:
gppaymentsYYYYMMDDHHMMSS

Example:

gppayments20220125080000

How do I tweak so I can specify the file name?

Thank you in advance

Answer 1

How's this?

$FileName = "C:\SQL\gppayments{0}.csv" -f (get-date -format "yyyyMMddHHmmss")
$FileName
Invoke-sqlcmd -ServerInstance DESKTOP-HG7ATKK\GP2018 -Database FARGO -query "Select * from IV00101" `
| Export-Csv -Delimiter "|" -Path $FileName -NoTypeInformation

Answer 2

How about this?

$filename = "C:\SQL\gppayments{0}.csv" -f (get-date -format "yyyyMMddHHmmss")
Invoke-Command . . . 
} | Export-Csv $filename . . .

Answer 3

Both suggestions worked beautifully. Thank you very much.

Answer 4

Hello BronTamulis

You can use define the filename append format as "C:\SQL\gppayments{0}.csv" -f (get-date -format "yyyyMMddHHmmss")

For instance:

$FileName = "C:\SQL\gppayments{0}.csv" -f (get-date -format "yyyyMMddHHmmss")
$FileName
Invoke-sqlcmd -ServerInstance DESKTOP-HG7ATKK\GP2018 -Database FARGO -query "Select * from IV00101" `
| Export-Csv -Delimiter "|" -Path $FileName -NoTypeInformation

another way should be using Get-Date as next

$SavePath = "C:\SQL"
$SavePathName = Join-Path -Path $LogPath -ChildPath "gppayments$(Get-Date -Format 'MM-dd-yyyy')"

---

--If the reply is helpful, please Upvote and Accept as answer--