JoshuaT (7/10/2013)
I want to first thank everyone for your time and assistance. I really appreciate it!I recreated my package and .xls file and in doing so I found that my file even though had a .xls extension and opened in excel without any issues was actually formatted as a .csv. This was the cause for the table format error. Once I saved the file in excel as .xls, the error was resolved. Unfortunately the application that provides the file does not truly deliver a .xls but merely alters the extension from .csv to .xls.
I have had that issue before.
Why I recomended deleting and recreating your source file.
I had forgot about this behavior but the new versions of EXCEL open files with extension of xls as a speardsheet if it can interpet the data into a set of field and row.