Thank you for your suggestion. I tried to go back to square one but I think it made things worse. I'm going to start a new topic which will explain my dilemna in detail with hopes that an SSIS guru will assist me with getting this very frustrating package to do what I need.