Import Flat File in SSIS
Posted on 2011-02-15
My flat file is ragged right with no column headings but has multiple headers, detail, footers.
I need to import the detail only and not the header/footers. I tried to import all and later delete the header and footers but not all the records are getting into my sql table. Does anyone know how this can be accomplished. I am new to SSIS and do not know how to set up a conditional split since I've read that this may be a solution. Appreciate any help ... ps this is urgent.