Add-Type -Path "C:\Oracle\product\12.2.0\client32\odp.net\managed\common\Oracle.ManagedDataAccess.dll"
$date = Get-Date -format "yyyyMMdd"
$username = "advanced"
$password = Get-Content "F:\SQL Sondage\password.txt"
$datasource = "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=GAZ-ODB-003.egd.enbridge.com)(PORT=1530))(CONNECT_DATA=(SERVICE_NAME=GCIPRD.egd.enbridge.com)));User ID=advanced;Password=xxxxxxxx;Min Pool Size=5;"
$query = Get-Content "F:\SQL Sondage\Queries\CO-VIG.sql"
$connectionString = 'User Id=' + $username + ';Password=' + $password + ';Data Source=' + $datasource
$connection = New-Object Oracle.ManagedDataAccess.Client.OracleConnection($connectionString)
$connection.open()
$command = New-Object Oracle.ManagedDataAccess.Client.OracleCommand
$command.Connection = $connection
$command.CommandText = $query
$ds = New-Object system.Data.DataSet
$da = New-Object Oracle.ManagedDataAccess.Client.OracleDataAdapter($command)

if($ds.Tables[0] == 0){
 return Add-Content F:\SQL Sondage\Output\Preformat\$date\CO-VIG-$date-2.csv "header1,header2,header3,header4"
} else {
[void]$da.fill($ds)
return $ds.Tables[0] | SELECT * | Export-CSV "F:\SQL Sondage\Output\Preformat\$date\CO-VIG-$date-2.csv" -NoTypeInformation -Encoding UTF8
}
$connection.Close()