we have 1 table (s1) database1 , loading data database (datbase2) , table (d1). implemented in ssis using oledb source (database1.s1) , oledb destination (datbase2.d1).
we have add new column 'addeddate' destination table. have used derived column in between source , destination.
now thought is, instead of using derived column can create added column in source itself? because need record loaded date.
yes, if use sql query in source (and should) have add column query.
something like,
select s1.column1, s1.column2, ... s1.columnn, getdate() recordloadeddate s1 ... 
Comments
Post a Comment