none
Derived Column Transformation

    Question

  • I use this function DATEADD( day,-1, getdate() ) in my Derived Column transformation, but I got error.

    It works for getdate(), but not DATEADD( day,-1, getdate() ).

    I need pass the information to my detination table previouse day informaiton.

    Are there any work around that I can use this function DATEADD( day,-1, getdate() ) in Derived Column Transformation?

    Your help and information is great appreciated,

    Regards,

    Souris,

    Friday, November 01, 2013 2:10 PM

Answers

  • yes, you can do that but a SSIS Expression syntax is unlike T-SQL uses "dd" to indicate a day

    DATEADD( "dd",-1, getdate() )


    Arthur My Blog

    • Marked as answer by sourises Friday, November 01, 2013 2:58 PM
    Friday, November 01, 2013 2:26 PM
  • The correct syntax is,

    DATEADD("d",-1,GETDATE())


    Regards, RSingh

    • Marked as answer by sourises Friday, November 01, 2013 2:58 PM
    Friday, November 01, 2013 2:24 PM

All replies