I found if you want to get rid of white space at the end of a column when you have variable length, then put in a Derived Column transformation and...

To get months and days...

declare @a1 date

declare @a2 date

select @a1 = '2014-01-05',

@a2 = '2014-02-04'

--Select CASE WHEN DAY(@a1) < Day(@a2)

SelectCASE WHEN DAY(@a1)...