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.

All Replies

• Tuesday, February 26, 2013 6:46 PM

  Moderator

   

   
  

  0
  Bad query

  ---

  Arthur My Blog
  

  • Reply
  • Quote

   
• Tuesday, February 26, 2013 7:06 PM

   

   
  

  0

  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

  • Edited by sql393 Tuesday, February 26, 2013 7:11 PM
  • Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, March 05, 2013 5:47 AM
  •  
  • Reply
  • Quote

   
• Tuesday, February 26, 2013 7:10 PM

  Moderator

   

   
  

  0
  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

  • Marked As Answer by Eileen ZhaoMicrosoft Contingent Staff, Moderator Tuesday, March 05, 2013 5:47 AM
  •  
  • Reply
  • Quote

   
• Wednesday, February 27, 2013 7:05 AM

   

   
  

  0

  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

  • Reply
  • Quote