May 21, 2012 at 9:30 am
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
May 21, 2012 at 11:28 pm
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
May 31, 2012 at 8:59 pm
ram11sql (5/21/2012)
HiI 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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy