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