Incorrect syntax when insert date

  • Hello,

    I'm using the scriptcomponent in SSIS, if I want to insert the date in my table, I'm getting the following error:

    Incorrect syntax near '22'.

    The time output is this: 31/07/2007 22:00:00

    If I use some testdata it only works with the following notation 31/07/200722/00/00

    Is it possible that signs like ":" and spaces are not allowed?

    Thanks in advance!

  • Nobody who knows how to delete the time from timedate?

    as example 22/07/2007 in stead of 22/07/2007 3:00:33

    Thanks

  • To obtain only date part using script component use code below -

    Row.Fieldname = Row.Fieldname.Date

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

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