January 18, 2010 at 9:05 am
I've developed a SSIS package to load data from SQL Server 2005 to Excel file. Basically it deletes the sheet (DROP TABLE), creates the sheet (CREATE TABLE) again and loads data to it. The reason I'm doing this is that I couldn't find a easy way to clear excel data before loading to it. It works pretty well for a few days. Then I got the error message:
Opening a rowset for "sheet1" failed. Check that the object exists in the database
When I opened the SSIS package with BIDS, I saw the connection has problem. The excel file has only a sheet named "sheet1$". I have to point the connection to "sheet1$". It worked for a while, then again I got error message saying that "sheet1$" doesn't exist. This repeated problem haunted me for a long while. Anyone has a clue about it?
Thanks a lot!
March 15, 2011 at 8:18 am
as a work around, you can write a script task to copy over a blank spreadsheet to your connecting spreadsheet every time instead of clearing it down...
March 15, 2011 at 8:22 am
darth_vodka (3/15/2011)
as a work around, you can write a script task to copy over a blank spreadsheet to your connecting spreadsheet every time instead of clearing it down...
I second this - it's easy and works.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
April 10, 2012 at 9:49 pm
My issue was that it's not "Sheet1" but "Sheet1$"
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply