A great start. Any thoughts on extending it to read the first line of the
file on disk. Could use XPcmdshell or write some CLR creating a assembly
and have the function reference it to read the disk file for the header,
also could enhance to prompt for field type and lengths.
I have hand crafted many a format file for use with BCP. It always was a
pain and takes a while. In the data I am dealing with we normally have in
excess of a hundred columns so as you can see... very painfull to do it manually.
We use BCP and in many cases Bulk Insert (Which is faster), using these same
format files. We are normally loading 8 to 10 million rows, so we need something
At any rate great job !