>> Are there any other settings (for SQL Server or Windows) which I should look at?

Check out SET DATEFORMAT in the BOL.

What task are you using to read the text file and convert the date?

I believe that when you launch a DTS package from within the SEM, it's actually running on the machine that is hosting the SEM. To get a more accurate test, you should start the job directly.

-Mike