Search Results: Breakpoints

• 
  HRESULT E_FAIL Error when trying to add Breakpoints

  I ran into a small problem this morning when trying to test an SSIS package. I simply wanted to add a breakpoint to a Foreach Loop Container to pause the package at the beginning of each iteration of the loop. Pretty straight forward, yes? Well I thought

  Author:  kylewalker     Date: 8/12/2011     Section: Blog

  tags : Breakpoints
• 
  Help with Script Component Issue

  The Script Component does not support the use of breakpoints. Therefore, you cannot step through your code and examine values as the package runs. There are a few workarounds to still get some form of debugging. // C# Code System.Windows.Forms.MessageBox.

  Author:  SSISJoost     Date: 4/5/2011     Section: Forum

  tags : DEBUG, SCRIPT component, SSIS
• 
  SSIS Package Development Troubleshooting Tips

  When developing an SSIS package, sometimes it can be frustrating trying to troubleshoot various issues and faults with the package. And if you're not a seasoned SSIS developer, you may not be sure about the best way to solve your problem. Thankfully, Micr

  Author:  DustinRyan     Date: 5/28/2010     Section: Blog

  tags : Data viewer, debug window, Troubleshoot SSIS package
• 
  SSIS Tips: Watch Your Variables!

  In today?s post, I will give you some tips on monitoring the values of your variables when working with SSIS packages in BIDS. We can look at two different situations.   First, I will show how to view variable values when using loop containers. Once

  Author:  ShawnHarrison     Date: 12/15/2011     Section: Blog
• 
  Using SSIS user variables between Script Task and Script Component

  Hi Mike, I was just watching your SSIS troubleshooting webinar today and when I saw how you used breakpoints on the pre and post execute events, I tried that on my package to monitor the variable settings. (just as you recommended in your answer). The var

  Author:  kjones140     Date: 1/28/2011     Section: Forum