I have a RAW data source with Sales and Date column. So, I want to assign the min(Date) to all the records using ssis only.
e.g.
create table temp(sales int, date datetime)
insert into temp select 5,'11-12-2011'
insert into temp select 6,'5-12-2011'
insert into temp select 7,'12-12-2011'
insert into temp select 8,'1-1-2010'
so the output should be
5,,'1-1-2010'
6,'1-1-2010'
7,'1-1-2010'
8,'1-1-2010'
We cant use Min, Max functions in Derived Column transformation..so how to achieve this?
Please help guys..Thanks in advance