How to get semester value in SSIS ? RRS feed

  • Question

  • through SSIS package,(ole db source)sales order header i have orderdate.

    from year(orderdate) i'll get year value, month(orderdate) i'll get month value.

    Now my ques is in need to display the value of semester as 1 for 1-6 and 2 as 7-12.

    can i do it  using derived column?

    Wednesday, December 7, 2011 5:59 PM