|Frank Bischof c947c7ed39|
Monthly SQL Query automation
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.