I have an SSIS package which is loading a table from a text file. I am in a dd/mm/yy enviroment and the text file contains a field in dd/mm/yy format. Using VS2005 to execute the package everything works fine loading the database in yy/mm/dd format, however when I run the package from the SQL agent some of the dates are converted incorrectly for example
7/11/06 results in 2006/07/11 instead of 2006/11/07.
The control panal of the server is set to d/m/y and as I said when running the package manually all is well.
Carl