Making calculations in a SSIS package

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.

Thanks,
lostboyinsoflaAsked:
Who is Participating?
 
Einstine98Connect With a Mentor Commented:
in the data flow section in the tools on the right-hand side there should be a "dervied column" object... use that...
0
 
Einstine98Commented:
you need to create a calculated field and map it to your destination in SSIS
0
 
lostboyinsoflaAuthor Commented:
How do I do that?  I'm really just beginning with SSIS and don't know much of squat yet.
0
 
lostboyinsoflaAuthor Commented:
Where in the hierchy do I put it?  Right now under Data Flow I have:
OLE DB Source
Aggregate
OLE DB Destination
0
 
Einstine98Commented:
after or before the aggregate depending on when do you want your data transformed...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.