April 28, 2010 at 3:27 am
Hi All,
Can anyone tell me if we can upload an Excel 2007 file into database in SSIS while the filters are turned on in the excel.
My excel upload fails when the filters are turned on. Excel has only one sheet named Sheet1.
In my first DFT I use a script component to loop through the sheets and get the names.
So, when I saw the sheet names through dataviewers I found two sheets instead of one.
Sheet1$ and Sheet1$_ . Then I found in a post that we get the Sheet1$_ sheet wen the filters are used in the excel. My package loops through the sheets and encounters a problem wen it comes to Sheet1$_ since there is no data present in this sheet.
With Regards,
Anu..;-):hehe:
April 28, 2010 at 3:50 am
Got a fix myself....
this problem persists even after removing the filters to the sheet. Filers will be disabled but the sheet Sheet1$_ will still exists. To resolve this , I added a code to my DFT. While looping through the sheet names , if the sheet name contains _ at the end remove the sheet or else proceed with your action.
Worked fine for me.....
Is there any workaround for this ??
Thanks all...
With Regards,
Anu..;-):hehe:
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply