title: SQL Server Import and Export Wizard and PostgreSQL
body: <p>I am trying to export data from PostgreSQL to MSSQL Server. </p>
  
  <p>Currently, I am exploring the SQL Server Import and Export Wizard. </p>
  
  <p>I have installed the <em>native postgres driver</em> and got the <strong>.Net Data Provider for PostgreSQL</strong>. Everything seemed fine until I tried to use it. </p>
  
  <p>I got the following: Cannot get the supported data types from the database connection </p>
  
  <p><a href="https://i.stack.imgur.com/Wk9YM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Wk9YM.png" alt="postgre native driver problems"></a></p>
  
  <p>Is this a driver problem or am I missing something? </p>
  
  <p><strong>Update:</strong></p>
  
  <p>Like <strong>@Panagiotis Kanavos</strong> suggested I have installed <a href="http://pgfoundry.org/projects/oledb/" rel="nofollow noreferrer">OLEDB driver</a></p>
  
  <p>There seems to be a problem with it. </p>
  
  <p>I fill the required data, Test the connection, it says that it is successfully established, but when I click Next to continue with the Wizard I get:</p>
  
  <p>===================================</p>
  
  <p>Cannot get string literals from the database connection "Provider=PostgreSQL OLE DB Provider;User ID=postgres;Data Source=localhost;Location=MyDb;Extended Properties=". (SQL Server Import and Export Wizard)</p>
  
  <p>===================================</p>
  
  <p>Object reference not set to an instance of an object. (DTSWizard)</p>
  
  <p>Here are some screenshots:</p>
  
  <p><a href="https://i.stack.imgur.com/wlnHQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wlnHQ.png" alt="enter image description here"></a></p>
  
  <p>After clicking Next:</p>
  
  <p><a href="https://i.stack.imgur.com/rqBcr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rqBcr.png" alt="enter image description here"></a></p>
  
  <p>There isn't any useful information about this problem. If anyone has any idea?</p>