elmoustabchir (5/8/2013)
thank youfor my first error , its a column like this : déc 5 2007 12:00AM ( i dont understand why it doesnt work because its pretty simple :s )
for my second im gonna take a look on a script and see what i can do
but i remember you i took the DB source , the SP et DB destination as they works on the production environement !
Are all your dates in French but default language of database English?
You can using SET LANGUAGE:
SET LANGUAGE French
select cast('déc 5 2007 12:00AM' as datetime)