Hi, I have a SSIS package in which I will create a excel file dynamically and write data into it. I am using Excel Destination component in data flow and pass data(mapping of data) into the excel file. At first, I will do a CREATE TABLE script(table name is 'anyName' for example) and thus the "Name of the Excel sheet:" would have 'anyName$' on it.
Next I will continue to do variable mappings. I have no problem executing the package but after some time(a few hours, a few days, etc) when I try to run it again, I would get an error message as above title.
There are 2 scenarios which I will get this error. One is when I run the package, another is when I try to open up the "Mappings" section in Excel Destination component.
Is this a bug in Excel Destination component? Or is it I simply missed out some setting?
What I have tried:
1. Reconfigure the "Name of the Excel sheet:" and everything back to normal.