Most efficient way to load fixed width flat file into SQL
Our vendors only send us text files in fixed width format. It will be millions of records with 200+ columns. Yes, I have loaded them using SSIS 2005 up to 2012. There has got to be a more efficient approach to load the files without having to click every column in import tool. Any suggestions? Thanks!