Debug Script Task in SSIS (SQL 2005)

Question

Hi,

I need a small clarification from here. I am using SSIS (SQL 2005). I have Script Task in my SSIS Package.

All I need to know that How can I debug my Script Task. I can able to set a break point in the script but when I am clicking on the "RUN (F5)". This is not working. Is there any configuration I missed or something else?

Please advice..

Thanks,
Sandeep

Answer 1

To debug the Script Task, open the task UI and click through to the script itself. (This is the VSA designer.) Now just add a breakpoint on a line of code. Close down VSA and the task UI. Run the package. When the breakpoint is hit, VSA will open up allowing you to step through the code.

if the break point is not working, 

1) remove the previous break point and set the new one.

OR

2) close the solution and try again

Note: SSIS does not (yet) support breakpoints in a script component.

Thanks-

---

Let us TRY this | Don’t forget to mark the post(s) that answered your question

Answer 2

There is a way to debug script task in the data flow task ...
import namespace : Windows.forms
and u than use MessageBox.Show(value); to see the value that u want to see
or other wise enclose ur code in try - and then catch the exception..

or do something like this

..
public override void Input0_ProcessInputRow(Input0Buffer Row)
    {
        bool fireAgain = false;
        this.ComponentMetaData.FireInformation(0, "MyScript", "Put your informational message here - perhaps the value of a variable in the script", "", 0, ref fireAgain);     }



dibmaz

Answer 3

u can debug a script component task  in control flow using breakpoints but not in dataflow..the dataflow one is a script task ... u cannot debug that using breakpoints...

Answer 4

u can debug a script component task  in control flow using breakpoints but not in dataflow..the dataflow one is a script task ... u cannot debug that using breakpoints...

You said just the opposite. Script component is in the DFT and Script task is in Control Flow.
In data flow if you need to check some value being set or not use MsgBox() in VB to show the value during execution.

---

Hope this helps !!
Sudeep   |    My Blog

Answer 5

Thanks for pointing that out ...

Answer 6

Hi ETL Vs. ELTL.

Excellent Man . I am really happy now...All I wanted that I got from your Post.
Now I am clear on this.

If I understood you clearly. 1st need to set break point. then save it. and execute package globally. then it is going to break mode...
then after we can do the research...rite.....

WELCOME MAN ....NICE ....It' ll help a lot (ETL )...

Nice Thing.....Thanks a lot.....
I appreciate this ...answer.. It is highly necessary for SSIS developers point of view..

Thanks....

Thanks,
Sandeep.

Answer 7

Voting ETLs post as helpful here.
Sandeep, please mark the helpful post as answer.

---

Nitesh Rai- Please mark the post as answered if it answers your question