CODEWITHSUNDEEP
ssis
Mntne Dav
Mntne Dav

Reputation: 93

SSIS datatype mismatch

I am trying to import from an oracle Source,I have a date field both on the source and destination.Its throwing error "there was an error with the input column on input OLE DB Destination failed with error code oxco209029A occured while processing input "OLE DB destination input(3554)". I am trying to cahnge it to char in the Oracle query and change it to back to date..in the SSIS using data conversion, and it didnt work as well,may be I am doing something wrong,Could you guys have alook at this?I really appreciate it..Thanks guys

Upvotes: 0

Views: 1117

Answers (2)

William Salzman
William Salzman

Reputation: 6446

Here are three of my previous answers on this topic.

https://stackoverflow.com/a/11585853/236348

https://stackoverflow.com/a/2231164/236348

https://stackoverflow.com/a/11229159/236348

Upvotes: 3

billinkc
billinkc

Reputation: 61211

Oracle and SQL Server date types are a known incompatibility.

etc.

You've cast the Oracle type to some string equivalent and SQL Server isn't accepting the input for a (date, datetime, datetime2?) data type. Generally your options are to clean up your cast to be a recognizable date format or add a Derived Column Transformation to change the input string column to the SSIS equivalent. The exact type depends on what your target table has defined.

Upvotes: 2

Related Questions