Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Error: Opening a rowset for "Tax_Difference" faile

Author  Topic 

sgandhi
Posting Yak Master

115 Posts

Posted - 2009-03-24 : 11:32:36
Hi, i have created an SSIS package that creates an excel spreadsheet with output to 4 different sheets. All all works ok, but the problem is that sometimes it will work and sometimes it will say

Error: Opening a rowset for "Tax_Difference" failed. Check that the object exists in the database.

Its very random when it fails. The distination connection has an expression on the excelfilepath as the @[user::excelfilename] variable and the delay validation is set to TRUE

Like it said, its random when it fails, but it fails with the above message.

Please help
   

- Advertisement -