Post reply

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

  • 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

  • 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

  • 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/

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply