How to create a dummy columns in SSIS 2008

Question

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:

score 0 · Answer 1 · answered May 23 '17 at 18:55

0

One way to do this is with the Derived Column Transformation.

answered May 23 '17 at 18:55

Tab Alleman

Hadi · Accepted Answer · 2017-05-23T20:31:39.820

0

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

edited May 23 '17 at 20:31

answered May 23 '17 at 19:00

Hadi

1

Thanks. It worked. Since my Target is Oracle i have to use GETDATE() only and the data type is Database Timestamp (DT_DBTIMESTAMP) – Ras Knorr May 23 '17 at 20:30
Happy to help. I edited the data type and upvoted ur question :) – Hadi May 23 '17 at 20:32
Thank you so much for the help. – Ras Knorr May 24 '17 at 04:04

2 Answers2