Reputation: 16239
I have created SSIS package
which will generate excel file
from sql table.
But when I try to execute 2nd time that same package after deleting that file (try to generate new file again) i'm getting following error
Error at Data Flow Task [Excel Destination [329]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E37.
Error at Data Flow Task [Excel Destination [329]]: Opening a rowset for "Excel_Destination" failed. Check that the object exists in the database.
Error at Data Flow Task [SSIS.Pipeline]: "component "Excel Destination" (329)" failed validation and returned validation status "VS_ISBROKEN".
Error at Data Flow Task [SSIS.Pipeline]: One or more component failed validation.
Error at Data Flow Task: There were errors during task validation.
Upvotes: 0
Views: 3725
Reputation: 1
To fix this issue. In the Excel connection manager properties you have to set the "DelayValidation" property to TRUE.
i think change "DelayValidation" on Dataflow Properties.
Upvotes: 0
Reputation: 812
To fix this issue. In the Excel connection manager properties you have to set the "DelayValidation" property to TRUE.
Upvotes: 1