We are replacing a development server and this has involved re-testing DTS packages on the new server.
We have hit an anomaly within a VB script within packages. Our package is called directly from a SQL job and, when we run this on the new server, it is building a filename with a suffix of the current date in M/dd/YYYY format. This is behaving differently to our previous server which was using dd-MM-YYYY format.
This is causing failures. Rather than change any such scripts, I need to find and fix the date setting that is defining the default format. Our SQL support team state they do not think there is an issue with SQL Server 2000 default date.
Interestingly, if I run the DTS package in Design pakage mode, it picks up the default server setting for my username (Uk date format) and works correctly i.e. uses dd-MM-YYYY format. It is simply when run from the job that US date is used.