title: The ole db provider used by ole db adapter cannot convert between types dt_dbtimestamp and dt_numeric in SSIS
body: <p>I am planning to insert current date time in SSIS project but I am getting</p>
  <blockquote>
  <p>The ole db provider used by ole db adapter cannot convert between types dt_dbtimestamp and dt_numeric</p>
  </blockquote>
  <p>In my current table, CurrentDate field is datetime2(7).</p>
  <pre><code>INSERT INTO [Table](CreatedDate)
  VALUES (CURRENT_TIMESTAMP)
  select ? = SCOPE_IDENTITY();
  </code></pre>