title: Default AlwaysUseDefaultCodePage to True Globally in SSIS
body: <p>In SSIS, when connecting to certain non-SQL Server databases via the OLE DB provider you may encounter this error:</p>
  
  <blockquote>
    <p>Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.</p>
  </blockquote>
  
  <p>This error can generally be suppressed by setting the <code>AlwaysUseDefaultCodePage</code> property to <code>True</code> on the Source component.</p>
  
  <p>My question is, can the <code>AlwaysUseDefaultCodePage</code> property be set so the default is <code>True</code>?  It's a bit annoying to always have to set this for each source.  </p>
  
  <p>Assuming it IS possible, would there be instances where this would actually be bad?  I haven't been able to determine if there would ever be a case that this would cause an issue.  I'm mostly dealing with Informix (en_us.819 locale) and MS SQL Server (Latin1 collation), if that helps.</p>
  
  <p>Thanks.</p>