Excel file connection nit getting closed in Foreach ADO.NET Schema Rowset Enumerator

• ram11sql

  Old Hand

  Points: 392

  More actions

  May 21, 2012 at 9:30 am

  #256665

  Hi

  I am using "Foreach ADO.NET Schema Rowset Enumerator" to get sheet names, but excel file connection is not getting closed after the loop is completed. How to close the file once exection of reach "ADO.NET Schema Rowset Enumerator" is completed.

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259155

  More actions

  May 21, 2012 at 11:28 pm

  #1490830

  Do you bump into a specific error?

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  May 31, 2012 at 8:59 pm

  #1495627

  ram11sql (5/21/2012)

  ---

  Hi

  I am using "Foreach ADO.NET Schema Rowset Enumerator" to get sheet names, but excel file connection is not getting closed after the loop is completed. How to close the file once exection of reach "ADO.NET Schema Rowset Enumerator" is completed.

  Thanks

  This sounds like a bug in the Foreach loop container. I would recommend you file a bug report at SQL Connect.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/