I have a csv file that I want to process in SSIS. The file contains a column type string Unicode string [DT\_WSTR], example: ColumnA -> (`"00000123400"`).

I want to delete the zeroes that are on the left of 123400 and also delete the quotes and have a result as following: `123400`.

For quotation marks I find the following solution via Derived Column: `REPLACE (ColumnA, "\" "," ")`, which gives me the following result: `00000123400`.

How to remove the zeroes which are on the left?

After deleting the quotation marks, I tried to convert my string to integer [DT\_I4], but that does not remove the zeroes.

Do you have the answer to my case? Thanks in advance.