Im going crazy, I'm transferring some data bases on two sqlserver 2008R2 the first and the second 2005.
Being in Italy for transfer using the format 'yyyy-mm-dd hh: mm: ss: nnn'
The DTS have in query transform for fields that are datetime specification:
cast ('<value>' as datetime)
and for those smalldatetime use
cast ('<value>' as smalldatetime)
, where in both cases the '<value> 'is in the format indicated above.
On SQLServer 2008R2 everything is OK, while on SQLServer 2005 I always reports that the date value is outside the allowed range.
I have verified that both servers use the same SQL COLLATE and that the base language is the same (italian) and that the regional settings are correct.
I can not understand, I have tried in the properties if there is any particular specification, but have not found anything.
Someone can give me the right direction to solve this problem.