Select MIN of a column

• rockstar283

  SSCrazy

  Points: 2704

  More actions

  August 9, 2011 at 8:46 pm

  #255483

  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

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  August 10, 2011 at 3:55 am

  #1366447

  The following thread seems to have some answers:

  http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/deeba026-6be1-45db-b413-1969bbbe247b

  😉

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP