Remove double quotes from CSV file in SSIS

We are getting the CSV file and we need to load this data into the database. Our CSV file data are enclosed with Double Quotes. We need to remove the Double Quotes from the data and load it in the database.

Below is the sample file.   

We need to load these data into the table.

Taking Flat file as Source and creating the connection.

   

Go to the Columns. We will see the below screen.  

All data in the Double Quotes.

To Remove these Double Quotes we need to set the below the property when we are creating the File Connection.

 

In the General tab, we need to set the Text Qualifier Property as “ . By default value of this property is none.

Now we are taking the Multicast and adding Data viewer to see the records.  

Running the package now.

 

See now the Double Quotes are disappeared.