Have old MS DOS batch files (yup).
They do some funky stuff and one of them is to do BCP to a file.
I am trying to get rid of the "write to file" portion for a number of reasons and instead, as a stepping stone in aid of another process, get the data BCP see's and put it into a byte array (varbinary) and place that into a SQL Table.
- how do you do that using BCP?
- I would hope that if I extract the byte data back into a file that it will be in the correct format and nothing gets altered.