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:
if you stick that into a staging table, it might be two varchar fields:
the datatypes form a file are probably wrong, you probably need to convert the field to decimal/money, first?
and finally, for th3e varbinary value, to insert then , it's probably like this:
INSERT INTO FinalTable
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!