SSIS error:package Validation Error. SSIS Error Code Dts_e_oledberror. . Error code:0x80040e37. An OLE DB record is available. Hresult:0x80040e37

A validation error occurs when I try to dynamically create a global temporary table # #Temp in the SSIS package, use the lookup component as a data source, and assign a value to a global temporary table variable when I refer to the following link.

Http://sqlage.blogspot.com/2014/04/ssis-how-to-create-use-temp-table-in.html

Because the information has been explicitly prompted, this is a validation error, this is another dynamic creation of the global temporary table package, so I suspect that is the DelayValidation property setting problem. When I checked all the database connections, this property was set to Ture. I was confused, then inadvertently click on the Control Flow page blank, go to the package's properties page, found Delayvilidation set to False, Double-click to set the property value to Ture, press F5 to execute,

, the duang! shows successful operation and the problem is resolved successfully.

SSIS error:package Validation Error. SSIS Error Code Dts_e_oledberror. . Error code:0x80040e37. An OLE DB record is available. Hresult:0x80040e37