Help with removing double quotes

Welcome Forums General PowerShell Q&A Help with removing double quotes

Viewing 1 reply thread
  • Author
    Posts
    • #279561
      Participant
      Topics: 2
      Replies: 0
      Points: 23
      Rank: 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:

      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?

       

       

    • #279567
      Participant
      Topics: 17
      Replies: 1951
      Points: 3,986
      Helping Hand
      Rank: 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

Viewing 1 reply thread
  • You must be logged in to reply to this topic.