title: SSIS data transfer adding characters (SQL Server to Postgres)
body: <p>I've created an SSIS package that takes geography data out of a SQL Server database and copies it to a geometry column in a <code>Greenplum</code> Postgres database.</p>
  
  <p>I'm doing it in a roundabout way because of weird errors with the PGNP driver when trying it the normal way. So what I'm doing is using <code>GeogColumn.STAsText()</code> on the SQL Server source and inserting that into a text column in the <code>Greenplum</code> database, then running a task that updates the geometry column in the <code>Greenplum</code> table using the newly inserted text, which should e.g. look like <code>POLYGON(-85 42, -86 43)</code>.</p>
  
  <p>The problem is that <strong>\\000</strong> is getting added after each character and then the update won't work.  Here's what it looks like:</p>
  
  <p>Source
  <img src="https://i.stack.imgur.com/QZrd4.png" alt="enter image description here"></p>
  
  <p>Destination</p>
  
  <p><img src="https://i.stack.imgur.com/SvrXl.png" alt="enter image description here"></p>
  
  <p>How do I stop this from happening?</p>