Post reply

AlwaysUseDefaultCodePage Property

  • October 7, 2009 at 11:30 am

    #226871

    Is there a way to set AlwaysUseDefaultCodePage Property to true or false for all the ole db sources defined in your dataflow task. I have over 250 ole db sources. they all map to same source connection but each to reading a different table.

    ideas?

  • November 25, 2010 at 8:39 am

    #1255589

    Hi,

    I would recommend editing dtsx file in text editor eg. Notepad++ and look for AlwaysUseDefaultCodePage and change pattern:

    AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">false</property>

    to

    AlwaysUseDefaultCodePage" dataType="System.Boolean" state="default" isArray="false" description="Forces the use of the DefaultCodePage property value when describing character data." typeConverter="" UITypeEditor="" containsID="false" expressionType="None">true</property>

    HTH,

    Lukasz

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply