Making calculations in a SSIS package
Posted on 2006-07-06
I'll try to explain this best I can. I have a OLE DB Source that I run to an Aggregate that I then run to an OLE DB Destination. I map the fields I want from the source to the destination and that's that.
I have two fields in particular from the source connection named RATE and FACE. Both fields are DT_R8 datatypes. Whatever that means. They both are basically decimal values carried to the 4th digit. (00.0000).
Everything works very well getting my data out of the source and into the destination, however, somewhere along the path I need to do a calculation on the RATE and FACE fields. The RATE field is already being mapped to the DECRATE field in the destination table and the RATE is already being mapped to the DECRATE field in the destination table.
I need to multiply the RATE field with the FACE field though and insert that into another field in the destination table called DECCERTBALDUE and I don't know how.
I am just beginning to learn to use SQL Server Business Inteligence so I really not very good with it yet.
ANY help is welcome.