not able to create csv file

Thanks,

Anu

Try this

#Variable to hold variable  
$SQLServer = "your_server_name"  
$SQLDBName = "database_name"  
$uid ="sa"  
$pwd = "password"   
$delimiter = ";"

#SQL Query  
$SqlQuery = "SELECT * FROM $SQLDBName.dbo.MEQA5TableLogs;"  
$SqlConnection = New-Object System.Data.SqlClient.SqlConnection  
$SqlConnection.ConnectionString = "Server = $SQLServer; Database = $SQLDBName; Integrated Security = True;"  
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand  
$SqlCmd.CommandText = $SqlQuery  
$SqlCmd.Connection = $SqlConnection  
$SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter  
$SqlAdapter.SelectCommand = $SqlCmd   
#Creating Dataset  
$DataSet = New-Object System.Data.DataSet  
$SqlAdapter.Fill($DataSet)  
$DataSet.Tables[0] | Out-File "D:\export.csv" 
$DataSet.Tables[0] | export-csv -Delimiter $delimiter -Path "D:\export.csv" -NoTypeInformation  

Save the avobe script to a ps1 type file and run the file using powershell.

Powershell.exe -executionpolicy remotesigned -File  D:\ps.ps1