• elmoustabchir (5/8/2013)


    thank you

    for 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)

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]