You can't debug (via F5) an SSIS Script Component - whether or not you've got Office references in it or not. In order to debug a Script Component (and let's make sure it's a Component, not a Task), you're going to have to upgrade to to 2012... or use non-interactive debugging techniques. A common technique is to use System.Window.Forms.MessageBox.Show(). I prefer Dts.Events.FireInformation (in Tasks) or the equivalent ComponentMetaData.FireInformation (in Components). Talk to me now on

Thanks for your replies ....so we can debug Script task but not script component ...

In 2008R2 and below, yes, you can debug the Script Task and not the Script component. However, to debug the Task, you don't F5 while in the script. Place breakpoints in the code, then close the code and script editor and start your package. Talk to me now on

Hi, I have opened the script component and tried to run the script for debugging ,however , i face the above error. I am using Microsoft Office 2007 and visual Studio 2008. could you please help me as how to get rid of this error. I remember that i was able to run the scripts previously.

You can't debug script components in SSIS 2008, that feature was added in 2012. See here for other ideas on how to debug http://msdn.microsoft.com/en-us/library/ms136033(v=sql.105).aspx Chuck Pedretti | Magenic North Region | magenic.com

You can't debug (via F5) an SSIS Script Component - whether or not you've got Office references in it or not. In order to debug a Script Component (and let's make sure it's a Component, not a Task), you're going to have to upgrade to to 2012... or use non-interactive debugging techniques. A common technique is to use System.Window.Forms.MessageBox.Show(). I prefer Dts.Events.FireInformation (in Tasks) or the equivalent ComponentMetaData.FireInformation (in Components). Talk to me now on