sql-serveroracle-databasessisetlattunity

How to create a dummy columns in SSIS 2008

I have a Flat file (.csv)

ID, Name
1, ABC
2, CDE
3, DEF

I want to the Insert these columns into the target Oracle Table with the sysdate to be inserted into the Load_Dt Column

Create Table Temp1
(Load_Dt Date,
ID Number,
Name Varchar2(10));

Environment:

Solution

  • In the DataFlow Task add a Derived Column Transformation

    Add a new column of type DT_DBTIMESTAMP with the expression:

    (DT_DBTIMESTAMP)GETDATE()

    Read more about Derived Column Transformation in this Microsoft Docs article