power

power shell to remove doube quotes in ssis 

 put this two lines as ssis task 

                    C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
                    -ExecutionPolicy Unrestricted -File "C:\serverpath\Test.ps1"

power shell file Test.ps1

# Set the path to your CSV file

$csvFilePath = "C:\serverpath\File.csv"

# Read the CSV file as a string

$csvContent = Get-Content -Raw -Path $csvFilePath

# Remove double quotes everywhere

$csvContent = $csvContent -replace '"', ''

# Save the updated string back to the CSV file

$csvContent | Set-Content -Path $csvFilePath -Force

#This script uses the -Raw parameter of Get-Content to read

before CSV file data

Col1,col2,col3,col4

102,shyam,14,13

102,"Ram,14,13