Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

insert data into varbinary datatype column---------very urtgent. Expand / Collapse
Author
Message
Posted Friday, March 29, 2013 1:48 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, January 29, 2016 12:44 AM
Points: 257, Visits: 616
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
Post #1436836
Posted Friday, March 29, 2013 6:11 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:09 PM
Points: 13,975, Visits: 36,293
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!
Post #1436886
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse