If you ever try to debug a script task by setting a breakpoint and the package is on a 64 bit machine it will just ignpore the breakpoint.
I ran into this problem myself a while ago and this week a co-worker also ran into it and asked me how to resolve it.
It is pretty simple, all you have to do is click on Project, then select Debug Properties. Under Configuration Properties, click on Debugging. Make Run64BitRuntime False. See image below.
Now start the debugger again, you will see now that it will stop at the breakpoint.
I also captured it in a video and uploaded it on YouTube, there is even a HD 720p format
*** Remember, if you have a SQL related question, try our Microsoft SQL Server Programming forum or our Microsoft SQL Server Admin forum
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
