I have a SSIS package that brings data from Db2 to SQL Server for 20 tables. All my 20 DFT tasks are inside sequence container. the package is deployed in SSISDB and it intermittently throws the error for one particular object during pre-execute phase.
An OLE DB error has occurred. Error Code - 0x80040E14
check that the object exists in the database.
Source failed the pre-execute phase and returned the error code 0xC02020E8"
Now the object exists in the destination database still it throws the error. The package has all the default settings.
I was reading that changing DelayValidation
property to True can resolve the issue. But this DelayValidation
exists at 1) the package level, 2) the connection manager level, and 3) at the DFT level. Where should I modify it?
User contributions licensed under CC BY-SA 3.0