After successfully deploying my SSIS package, the job in SQL Server was failed. Apparently this is something to do with SSIS data flows connecting to my database but I can't figure what's wrong. The error code from the log file is below.
I would appreciate any suggestions.
errror msg: [table_A Source ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "IBM OLE DB Provider for DB2" Hresult: 0x80040E07 Description: " CLI0113E SQLSTATE 22007: An invalid datetime format was detected; that is, an invalid string representation or value was specified. SQLSTATE=22007".
[SSIS.Pipeline] Error: table_A Source failed the pre-execute phase and returned error code 0xC0202009.
add a function to convert those NULLs to valid date value. You can do it either inside source query using DB2 functions (I'm not faimilar with DB2 so you need to serach it out). You may also chose to do it in SSIS using derived column task.