I haven't had any luck with fixed column files (as it sounds like you are trying to do). I was able to get all of my vendors at my previous place of employment to move to comma delimited. For the one that would not move, they didn't get updates more than once per month since I had to use Access to export the data.

I just found a process here with my new employer that does create an export but uses an "export table" generated from a stored procedure to build each record. Then, the SSIS package simply exports a single column without text qualifiers or delimiters.