Search code examples
sql-serverssisetloledbdestination

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

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

Solution

  • 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