June 18, 2012 at 5:02 pm
our client submit an excel file every week and it was processing fine until a couple of months ago...If i run the old excel file it works fine and inserts the data into the database...Now a different person is submitting the excel file, it doesn't load data into the database but if i copy the new data(coming from the new excel file) inside an old excel file(which we used to get before from a differnt person) it works fine and all the data is inserted into the database..
When i try to preview the Excel OLE DB source i get the following error message
"Opening a rowset for Sheet1 failed. Check that the object exists in the database"
Note both the files are in xls format
Not sure, and couldn't figure out what's going on
Any suggestions??
June 20, 2012 at 12:17 am
The sheet names are still the same?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 20, 2012 at 2:37 am
Hi Sandy
Is this the same problem you reported at the Integration Services forum?
Hope this helps,
Rock from VbCity
June 20, 2012 at 10:54 am
Yes it is, the problem is resolved now.....
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply