example of generating excel dynamically in ssis? geting error [Excel Destination [190]] Error: Opening a rowset for "Excel_Destination$" failed. Check that the object exists in the database.

Question

example of generating excel dynamically in ssis? geting error [Excel Destination [190]] Error: Opening a rowset for "Excel_Destination$" failed. Check that the object exists in the database.

Answer 1

Bad query

---

Arthur My Blog

Answer 2

Hi Vijay

Can you be little bit more specific, did you receive this error when you are designing this pacakge using BIDS

Becuase when you are designing this pacakge in BIDS, you need to manaually create a excel sheet manually for the first time you run,

are you creating excel sheet using execute sql task and excel connection with input from a variable?

Did you receive this error in validation phase or execution phase ?

Can you share your query to create table in excel ?

http://sqljunkieshare.com/2012/02/28/how-to-create-and-map-excel-destination-dynamically-in-ssis/

Use the above post

Answer 3

The common way is to have an empty copy of the excel sheet and use a FIle System Task to copy that file to the destination location before filling it with the Data Flow Task.

---

Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Answer 4

This Error is because of mainly it is not able to access the excel sheet or the sheet name does not exists in the excel sheet you have pointing..

Regards

Naveen