function GetSQL ($query)
{
    $Connection = new-object system.data.sqlclient.sqlconnection
    $Connection.ConnectionString = "server='servidor';database='basededatos';trusted_connection=true;"
    $Connection.open()
    $Command = New-Object System.Data.SqlClient.SqlCommand
    $Command.CommandText = $query
    $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
    $SqlAdapter.SelectCommand = $Command
    $Command.Connection = $Connection
    $data = New-Object System.Data.DataTable
    $SqlAdapter.Fill($data) | Out-Null
    $Connection.Close()
    return, $data
}

$query = "EXEC	[traffic].spPax;"
$Date = Get-Date -UFormat "%Y%m%d";
$outFile = "C:\scripts\CONTEXT_" + $Date +".csv"
$result = GetSQL $query
$result | Export-CSV $outFile -NoType -Encoding UTF8 -Delimiter ","  

$a = $outFile