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