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.
http://sqlage.blogspot.com/2014/04/ssis-how-to-create-use-temp-table-in.html

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: https://www.cnblogs.com/HlxDo/p/4544378.html

Read More: