title: SSIS DB2-> SQL Server data migration issue (Timestamp -> DateTime2)
body: <p>we are trying to transfer data from DB2 -> SQL Server 2014 database. When using SSIS to transfer data between tables, the timestamp -> datetime2 is failing due to data type mismatch. Found couple of links related to that, but not sure if they have the source db2 Timestamp column data converted to  string format before applying those conversions or data is coming in as Timestamp type and those conversions could still work?</p>
  
  <p>please share how to handle this Timestamp -> Datetime2 mismatch in SSIS.</p>
  
  <p>1) <a href="http://blog.appliedis.com/2012/09/24/best-practices-staging-mainframedb2-data-to-sql-server-2012-2/" rel="nofollow">http://blog.appliedis.com/2012/09/24/best-practices-staging-mainframedb2-data-to-sql-server-2012-2/</a></p>
  
  <p>2) <a href="https://social.msdn.microsoft.com/Forums/sqlserver/en-US/33eabd7d-b4ff-49b0-b053-ecfc575414ab/db2-timestamp-to-sql-server-2005-conversion?forum=sqlintegrationservices" rel="nofollow">https://social.msdn.microsoft.com/Forums/sqlserver/en-US/33eabd7d-b4ff-49b0-b053-ecfc575414ab/db2-timestamp-to-sql-server-2005-conversion?forum=sqlintegrationservices</a></p>
  
  <p>regards
  aravias</p>