CODEWITHSUNDEEP
ssisbids
cool breeze
cool breeze

Reputation: 4811

Getting an error saying to check for the object to exist with a excel destination

error at data flow tax excel destination open a rowset for $SHEET234 failed. Check that the object exists in the database

I'm getting the above error when trying to export data from sql server to an excel file.

Why is it giving me an error saying, which I am assuming is because the file doesnt' exist? But the whole point of an excel destination is to create the file for me no?

Upvotes: 0

Views: 2037

Answers (2)

Mike
Mike

Reputation: 459

I had the same problem. Similar to DEEPAK LAKHOTIA, after renaming the worksheets (right-click on the tabs) and removing the white spaces and decimals, the problem disappeared and the data loaded.

enter image description here

Upvotes: 0

DEEPAK LAKHOTIA
DEEPAK LAKHOTIA

Reputation: 993

Is there a space in your Excel file name? If so, try removing the space and testing it in a new Data Flow Task and see if that helps. Hope it helps.

Upvotes: 1

Related Questions