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

1.1k views Asked by At

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?

enter image description here

1

There are 1 answers

0
Hadi On BEST ANSWER

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