Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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)
- [void]$da.fill($ds)
- if($ds.Tables[0] == 0){
- return Add-Content F:\SQL Sondage\Output\Preformat\$date\CO-VIG-$date-2.csv "header1,header2,header3,header4"
- } else {
- return $ds.Tables[0] | SELECT * | Export-CSV "F:\SQL Sondage\Output\Preformat\$date\CO-VIG-$date-2.csv" -NoTypeInformation -Encoding UTF8
- }
- $connection.Close()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement