Post reply

insert data into varbinary datatype column---------very urtgent.

  • March 29, 2013 at 1:48 am

    #275787

    Hi All,

    I am using flat file as source. there is a column which contains salary. in the target table datatype of salary is varbinary. If i am tryimg to insert record, the package is failing.

    How to do that.

    Thanks

  • March 29, 2013 at 6:11 am

    #1601980

    you'll need to insert the flat file into a staging table...the flat file doesn't contain a varbinary string, right?

    so you stick it in a table of the right data type, and then convert it to varbinary.

    so say the file had this row of values:

    BOB 45612.56

    if you stick that into a staging table, it might be two varchar fields:

    'BOB','45612.56'

    the datatypes form a file are probably wrong, you probably need to convert the field to decimal/money, first?

    SELECT 'BOB',CONVERT(money,'45612.56')

    and finally, for th3e varbinary value, to insert then , it's probably like this:

    INSERT INTO FinalTable

    select 'BOB',convert(varbinary,CONVERT(money,'45612.56'))

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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