Post reply

extraction of day month and year using SSIS

  • May 27, 2014 at 10:39 am

    #289301

    HI all

    i tried to extract day,month and year from a date using SSIS but i have problem

    in fact i used derived column

    these snap shots show my problem

    thanks a lot for any help

  • May 27, 2014 at 11:06 am

    #1716777

    You need to use brackets.

    DAY([DATE_ACTIVATION])

    That should help with the error.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • May 27, 2014 at 1:41 pm

    #1716842

    Thannnnnnnnks a lot :))))

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply