SSIS Error:Package Validation Error. SSIS Error Code DTS_E_OLEDBERROR. .Error code: 0x80040E37. An …

When I refer to the following link and try to dynamically create global temporary table ##Temp in the SSIS package and assign values to global temporary table variables using the Lookup component as a data source, the validation error shown in the figure below occurs.

Since the message has clearly indicated that this is a validation error and this is another package that dynamically creates a global temporary table, I suspect that there is a problem with the DelayValidation attribute setting. But out of my idation, I idation set the value of DelayVilidation to False. Out of my idation, I press F5 to execute the idation.

Duang! Indicates successful operation and problem resolved.

Reproduced in:

Read More: