SSIS Failed Pre-Execute Phase check that the object exists in db

0

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?

sql-server
ssis
asked on Stack Overflow Jul 19, 2019 by nick • edited Jul 19, 2019 by marc_s

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0