Help with removing double quotes

[sharpharp94 Participant Topics: 2 Replies: 0 Points: 23Rank: Member]

Hi,

No matter what i do  in SSIS to import this powershell produced csv and put the contents in a table it adds double quotes:

PowerShell

$MailUser | Select-Object -Property SAMAccountName, GivenName, EmailAddress, @{n="Password-Expires"; e={[System.Math]::Round((New-TimeSpan -Start $CurrentPWChangeDateLimit -End ($MailUser.PasswordLastSet)).TotalDays)}} | Export-Csv $outputFile -Append -NoTypeInformation -Encoding UTF8

1 2 3 4

$MailUser | Select-Object -Property SAMAccountName, GivenName, EmailAddress, @{n="Password-Expires"; e={[System.Math]::Round((New-TimeSpan -Start $CurrentPWChangeDateLimit -End ($MailUser.PasswordLastSet)).TotalDays)}} | Export-Csv $outputFile -Append -NoTypeInformation -Encoding UTF8

Tried doing derived columns like: REPLACE([“SAMAccountName”],”\””,””) but still not working

Is there anyway of outputting the above, just with commas and not the double quotes?

 

 

[Rob Simmers Participant Topics: 17 Replies: 1951 Points: 3,986Rank: Community Hero]

This is more of SSIS question. Typically, a double qoute would be specified as the Text Qualifier:

http://www.msbiguide.com/text-qualifier-property-in-ssis/

If you have SQL Management Studio installed, there is SQL modules available to take $MailUser and inject it into SQL with Write-SQLTable or Invoke-SQLCmd:

https://docs.microsoft.com/en-us/powershell/module/sqlserver/?view=sqlserver-ps

or using many other various methods if you do not want a pre-requisite of SQL Mgmt:

6 methods to write PowerShell output to a SQL Server table

[Author]

Posts