title: How can I ensure that data pulled from mysql database is recognized in Mssql and SSIS?
body: <p>How can I ensure that data pulled from mysql database  is recognized in Mssql and SSIS
  I am  pulling records from Mysql database which is on Linux  box and store the records on MSSQL database. When I get the primary key from the same records to compare with records that are already on MSSQL database table.  The sql or SSIS  are failing to compare the existing records. For example
  PK   Column1 ( From Linux on Mysql) Table1
  QT1     Blue
  QT2    Green</p>
  
  <p>PK  Column1( Windows MSSQL)  Table2
  QT1    Blue
  QT2   Green</p>
  
  <p>When I pull the same records and compare the sql is showing as if these records do not exist or not there.
  The sql is as follows
  Select * from table2 where PK NOT  IN (SELECT PK from table2). This is in Microsoft Server Integrating Services<br>
  But it is pulling all the records. What things should I do to ensure that it works properly? Are there any characters I should change? All the records are in the same case.
  Please help. </p>