How can I set alwaysusedefaultcodepage to true?


  • Hello,

    I am trying to import a tab delimited file into SQL server but get the following error:

    Error 0xc02020f4: Data Flow Task 1: The column "Composer" cannot be processed because more than one code page (37 and 1252) are specified for it.
     (SQL Server Import and Export Wizard)

    After googling for this problem for a while, it seems that the solution is to set alwaysusedefaultcodepage=true. However, although almost everybody suggests this solution nobody actually explains *how* or *where* this property is set.. :)

    Does anyone know how this property is set in SQL server?


    -- Savvas

    • Dipindahkan oleh Kenneth LeeOwner Rabu, 20 April 2011 04.18 forum cleanup (From:MSDN, TechNet, and Expression Profile and Recognition System Discussions)
    Kamis, 02 September 2010 12.47

Semua Balasan