I was getting a 0x80040E09 error, when exporting some rows to an Excel file in SSIS 2005. This was caused by the destination Excel file being read-only. After I cleared the read-only checkbox on the file, the error was resolved.
Error
Error: 0xC0202009 at Data Flow Task, Excel Destination [16]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E09.
Error: 0xC0047022 at Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Excel Destination" (16) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
2 Replies to “Solving the SSIS 2005 Excel Connection Manager error 0x80040E09”
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
Thanks for the tip. This resolved my issue.
Met to thank goodness. I’d added the template to SourceSafe which had made the templates I was copying from read-only and SSIS could not update them once copied to the new file.