January 2, 2013 at 5:12 am
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
January 3, 2013 at 2:03 pm
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
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy