title: How to transmit data from postgres SQL to Microsoft SQL without arriving as "NULL"-values at the Microsoft SQL server?
body: <p><strong>Background</strong>: I want to transmit data from a postgres SQL server to a Microsoft SQL server via SSIS. </p>
  
  <p><a href="https://i.stack.imgur.com/dwFEr.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dwFEr.png" alt="http://www.bilder-upload.eu/show.php?file=d58423-1442932408.png"></a></p>
  
  <p><strong>Problem</strong>: The data arrive with “<code>NULL</code>”-Values in the Microsoft SQL table even though the format of the source (postgres SQL server) and the format of the destination (Microsoft SQL server) are the same.</p>
  
  <p><strong>One example</strong>:</p>
  
  <p>Postgres SQL: Column defined as charactervarying(100)</p>
  
  <ul>
  <li>Test10InSt</li>
  </ul>
  
  <p>Microsoft SQL: nvarchar(100) </p>
  
  <ul>
  <li>NULL </li>
  </ul>
  
  <p>Does someone know how to solve that problem? </p>
  
  <ul>
  <li>Is it a special format I need to choose in the “Data transmission” and if so what format exactly?</li>
  <li>Does the problem originate at another place?</li>
  </ul>