>> I wonder whether there is some way similar to Bulk Insert for delimited text file to handle the fixed length file.

There's BCP but you're probably going to have to create a format file for each type of file that you'll want to load. Check out BCP.EXE in the BOL.

-Mike