title: SSIS - Can you set a default Sql Server connection manager provider in Visual Studio?
body: <p>In a Visual Studio Integration Services project, when I choose a new OleDB Connection Manager, the default setting is 'Native OLE DB\Sql Server Native Client 11.0'.</p>
  <p>According to <a href="https://docs.microsoft.com/en-us/SQL/relational-databases/native-client/SQL-server-native-client?view=sql-server-ver15" rel="nofollow noreferrer">this</a> MS article, this has been deprecated and instead, the 'Microsoft OLE DB Provider for SQL Server' should be used.</p>
  <p><a href="https://i.stack.imgur.com/S1Ewx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S1Ewx.png" alt="Screenshot of Microsoft Article on Sql Server Native Client" /></a></p>
  <p>Is there a way in Visual Studio to make the default provider:  'Microsoft OLE DB Provider for SQL Server'?</p>
  <p><a href="https://i.stack.imgur.com/xsIHG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/xsIHG.png" alt="Edited Screenshot of Default Providers in SSIS" /></a></p>