0

This is the Error message

SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "OLE DB Destination.Inputs[OLE DB Destination Input]" failed because error code 0xC0209077 occurred

This is my oracle date source format 

31-DEC-18

and this is my destination table 

[COVERAGEEFFECTIVEDATE] [varchar](10) NULL
Hadi
  • 36,233
  • 13
  • 65
  • 124
ETL - BI
  • 59
  • 9
  • 1
    Dates don't have a "format"; they are binary values. Also, if it's a date, why are you trying to insert it into a `varchar(1)`? A date is **never** going to fit into a single character. Use a date and time data type. – Thom A Jan 20 '20 at 09:11
  • Thank you i changed data type and it worked – ETL - BI Jan 20 '20 at 14:20

0 Answers0