SSIS cannot convert between unicode and non-unicode string data types
<p>I am new to <code>SSIS</code>, and have been asked to migrate data from a Postgres database, to SQL. There is no data transformation requirements. But I have hit an early snag.</p>

<p>I've create a <code>System DSN</code> on my machine for an ODBC driver to connect to the Postgres database, and it connects fine.</p>

<p>In SSIS, I created an ODBC Data Provider connection, and used the DSN I created. Connects well. I then create an ADO.Net data source, and select my source data connection. I select the table I want this flow to pull from, press Preview, and I see the data. All good.</p>

<p>I then create an OLE DB Destionation component. I can't use an ADO.Net Destination, as one of my fields is a '<code>GEOMETRIC</code>' type, and SSIS seems to have an issue with that. OLE DB allows it.</p>

<p>I connect the Source to the Destination, and then open the Destination item. I select the Destination table, select 'Mappings' and all is mapped perfectly.</p>

<p>I close that screen, but I see a red cross next to my Destination component.</p>

<blockquote>
  <p>"Column "pid" cannot convert between unicode and non-unicode string
  data types."</p>
</blockquote>

<p>This seems to be the case with ALL VARCHAR fields in my database. Do I need to create a Data Conversion or something for every table, and every VARCHAR in my database? Or is there a way to fix this?</p>