Thanks everyone for posts regarding this. Due to the immediacy of this issue I had to punt and go to a work around.

The FTP server is outside...

I was afraid of a response like that. The SQL Server I'm running is on a hosting companies computer. This is a Web App where I do not...

This is new development so I have the luxery of completely deleting the table data and running my code from scratch. After I clear the database table I run...

I've added logging to my SSIS Package and it shows it entering the package and the FOR EACH LOOP is logging this:

OnWarning,TIF FEL OlderEstates FEL,5/20/2008 2:32:33 PM,5/20/2008 2:32:33 PM,-2147368956,0x,The For...