March 2, 2016 at 11:53 pm
I am getting the below mentioned error message when running the SSIS package through the SQL Server agent.
Error: Opening a rowset for "Test_Table$" failed. Check that the object exists in the database.
Error: "Excel Source" failed validation and returned validation status "VS_ISBROKEN".
SQL Server 2014 Enterprise edition 64 bit
windows server 2012 r2 data center edition
Any suggestions.
March 3, 2016 at 3:00 am
Sounds like the structure of the spreadsheet is different from how it was when the package was designed.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
March 3, 2016 at 8:24 pm
Structure of the Table in the database is same as the table in the spreadsheet
March 4, 2016 at 2:27 am
sql2k8 (3/2/2016)
I am getting the below mentioned error message when running the SSIS package through the SQL Server agent.Error: Opening a rowset for "Test_Table$" failed. Check that the object exists in the database.
Error: "Excel Source" failed validation and returned validation status "VS_ISBROKEN".
SQL Server 2014 Enterprise edition 64 bit
windows server 2012 r2 data center edition
Any suggestions.
This error is saying to me that the Worksheet named Test_Table does not even exist in the Workbook, or possibly that the Workbook cannot be reached in the first place.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 5, 2016 at 11:09 pm
I got the issue resolved by running as an admin user.
Thank You for looking into the Issue.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply