PowerShell script export SQL to CSV add delimiter

Question

I'm doing a script to export data from a SQL Server database. I want to output a .csv file with as delimiter ";".

Here is my script:

#Variable to hold variable  
$SQLServer = "SERVEUR"  
$SQLDBName = "TOTO"  
$uid ="PS"  
$pwd = "password123"   
$delimiter = ";"

#SQL Query  
$SqlQuery = "SELECT * from $SQLDBName.dbo.SAGE_TO_PRESTASHOP;"  
$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 "E:\EXPORTS\export.csv"

Export-Csv documentation. Note the -Delimiter parameter. — G42
– G42, Commented Dec 12, 2018 at 11:21

Eric Weintraub · Accepted Answer · 2018-12-12 11:32:34Z

18

Replace your bottom line with this:

$DataSet.Tables[0] | export-csv -Delimiter $delimiter -Path "E:\EXPORTS\export.csv" -NoTypeInformation

answered Dec 12, 2018 at 11:32

Eric Weintraub

1,0771 gold badge11 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PowerShell script export SQL to CSV add delimiter

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related