calling stored procedures of mysql from sql server

• lathish2kumar

  Grasshopper

  Points: 15

  More actions

  January 2, 2013 at 5:12 am

  #272400

  when mapping the columns from sql server to mysql iam getting the following error in oledb command

  iam unable to map the destination columns

  the source contains data type dbtimestamp for created_date column

  [OLE DB Command [746]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.

  An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0"

  Hresult: 0x80004005 Description: "Conversion failed when converting character string to smalldatetime data type.".

  can any body solve this prb

• Orlando Colamatteo

  SSC Guru

  Points: 182276

  More actions

  January 3, 2013 at 2:03 pm

  #1573473

  You may need a Data Conversion Transformation your Data Flow in between your MySQL ADO.NET Source and your SQL Server OLE DB Destination.

  There are no special teachers of virtue, because virtue is taught by the whole community.
  --Plato