how to assign a constant value to a column in oledb destination in ssis

Question

i have a OLE DB destination which has a destination columns such as TrackDateTime , OperationTypeID, and TrxID .Here TrxID i will get a value from input column. But my requirements here is to get the values for TrackDateTime , OperationTypeID : Here TrackDateTime must be current date and time and OperationTypeID must be 2 always. How can I achieve this?

Answer 1

You can use a derived column transformation to generate fixed values:

TrackDateTime

GETDATE() 

or if you need the package execution date time:

[System::StartTime]

OperationTypeID

2

Helpful links

• Derived Column Transformation
• Derived Column Transformation in SSIS