I'm getting in some sheets (not all) of an Excel file this error when I use the EXCEL SOURCE component in SSIS: Error 0X80004005
i HAVE ERASED before two sheets in the data flow task.I have tried to create those same sheets but it throws an error (see below the image). And now some of the 24 sheets are not working at all. I have not changed the original excel filename, neither the names of the sheets. Even if I open a new package and try to recreate the data flow task... it still throws this error!! How to fix this?
User contributions licensed under CC BY-SA 3.0