Post reply

writes null float data

  • August 13, 2008 at 10:42 am

    #127099

    hi,

    so here is the problem:

    i have an excel file with a column as double-precision float [DT_R8](or this is what it shows in ssis). the data example in excel is

    76768

    78999

    9878F

    9898G

    but when trying to import to databse the ones with letter at the end is getting written as null.

    I have tried converting them to string but still same thing happens.

    any ideas?

    thanks

  • August 13, 2008 at 1:13 pm

    #857674

    I don't know, you tried the similar way..I suggest, use Conversion task in between and use dt-str data type there and use this derived column to map to destination column.

    -VG

  • August 14, 2008 at 2:18 am

    #857880

    thanks for suggestion i have tried that and tried through advance editor but didnt help

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

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