I haven't touched much about debugging but I admit that sometimes you have no other chance than analyzing a post-mortem dump or live dump to troubleshoot a problem. Our "Debugging Tools for Windows" package comes with a very hand VBScript : "adplus.vbs". It simplifies lots of things for us. I was...

Why the breakpoints that I set in my "Script Task" (not "Script Component" in the Data Flow *) never hits ? On a Windows 2008 x64 machine, you're running SQL Server 2008 x64. Let's say you added a single "Script Task"; you wrote a very simple MessageBox.Show("Hello World"); line and put a breakpoint...