Sorry, I should have been a little more clear. And thank you very much for answering. Yes you are right you do not always have to reset the columns. I guess I am getting a little exasperated with this reset columns thing.

I get .txt files from a lot of different companies that are supposed to be the same and many are. We get them pipe delimited with the same headers. Once in a while I have to edit a header to match exactly our requested format.

Can you tell me what constitutes a format change? I will do some more research online concerning format change but if you have any links or insight I would appreciate it.

I have been working with SSIS, if you total all my time, about 1 to 1.5 years but I am just now having to do some higher automaton. I have looked at possibly creating a file format with bcp and using sql server to do these uploads but I don't really want to go that route. I would prefer to keep it in SSIS because there are other things in SSIS I want to use in my final outcome.