Monthly SQL Query automation

Description

You can set the DB server and database in the config part of the script. You can specify settings:

$SQLServer = "dbserver1"  
$SQLDBName = "database"  
$delimiter = ";"

The SQL files queried for are:

$SqlFile = 'Query file 1'
$SqlFile = 'Query file 2'
$SqlFile = 'Query file 3'

These SqlFiles corespond to ea. "Query file 1.sql" and will be output to 'YYYYMMDD/Query File 1.csv' The script uses your windows credentials to log in to the server and execute the queries.