As occurring more often something simple is not so simple in SSIS (v 2008)
Situation before B.I. came in: data was loaded into linked tables in hidden excel sheets, there were macro's and manual adaptations.
After: Still hidden sheets but we replaced macro functionalities with SSIS and had to unlink the table to get rid of the pop-up when opening the files: "The following data may have been lost: -Table"
Since we unlinked the table (and by consequence deleted the connection) we can't address the hidden sheet anymore via SSIS: Excel Destination. Non-hidden sheets are no problem and are visible.
--> Question: how can you export to a hidden excel sheet? Since above action the sheet is not visible anymore in the Excel Destination windows, dropbox "name of the excel sheet".
Thanks in advance for any advice!! L
See Question&Answers more detail:os