none
SSIS Script Task Shows Nonexistent Breakpoint in Designer, Hangs While Validating

    Question

  • I've built an SSIS package in SSDT 2012.  The package was running successfully until I made a change to a script task.

    The task, written in C#, uses an OLE-DB connection to open an Excel workbook and load cell values from each worksheet into separate DataTables.  The table data is then stored in SQL Server. 

    I was opening and closing the connection for each sheet.  I then decided to try to make the code more efficient by only opening the .xls file once, looping over the sheets, and only closing it after all sheets had been loaded.

    I rebuilt the package.  Now, when I run it, SSIS reaches this script task (the last in the package) and hangs, displaying the yellow arrow indicating that it is validating the task:

      Any break point that I set in the script code is never reached.  (Oddly, if I stop running the package, open the script in VSTA, remove all breakpoints in the C# code, and then save the task, the package designer still shows a red circle, which I though indicated that the task contains breakpoints.)

    These seems like bugs in SSIS/SSDT.  What would cause the relocation of some script code to hang the validation process like this?


    - Mark Z.



    • Edited by Mark Zudeck Thursday, August 07, 2014 5:43 PM
    Thursday, August 07, 2014 5:37 PM

Answers

  • Okay, it turns out that I needed to delete all breakpoints at the package level. (I have no idea why that would be.  Never had to before.)

    To do this: Click on some blank space in the package, so you don't have any one task highlighted, and then pull down "Debug" and delete all breakpoints.


    - Mark Z.

    • Marked as answer by Mark Zudeck Thursday, August 07, 2014 6:40 PM
    Thursday, August 07, 2014 6:40 PM