I don't understand whythat is not working for you in the Derived Column Transformation .

I used exactly the same thing and works fine

any way attached is the package for the sample data that you provided.

After downlaoding, rename the package to .dtsx. I built this on VS2008

Below is the table structure

CREATE TABLE dbo.[Sample_CSV] (

[Co] int,

[Company Name] varchar(50),

[Customer Number]int,

[Customer Name] varchar(50),

[Invoice Date] datetime,

[Invoice] int,

[Units] int,

[ Invoice Price ] decimal(18,0),

[ Total Invoice ] decimal(18,0),

[ Accrual ] decimal(18,0),

[ Total Accrual ] decimal(18,0)

)