Not able to debug script task in SSIS

Question

In my SSIS package, I have a script task in addition to other tasks. When I put a debug point within the script task and run the package( on the whole), ideally, it is supposed to hit the breakpoint. but it now only opens a new VS window, shuts it after few seconds and a green tick is displayed over the task.

I tried setting the the Run64BitRuntime flag to false and also editted and saved the script task again. The issue persists. Any pointers on this ?

I have VS 2010 BI and the machine is 64 bit Windows Server R2

Yup. The pitfall of SSIS. I've never been able to debug a script task. I wonder if there's a workaround for this — TsSkTo
– TsSkTo, Commented Oct 1, 2013 at 9:38
Solution Explorer -> Project -> Properties -> Debugging -> Run64BitRuntime -> False — makciook
– makciook, Commented Oct 1, 2013 at 11:52

User1000547 · Accepted Answer · 2015-02-24 16:11:51Z

8

Yes, break points do work in script task. But if that was a script component, then it wouldn't have worked. Any way, if you have a script task, the reason it might not be working is that it may be using the 64 bit runtime. Try running it in the 32 bit runtime.

Also, make sure that the place at which you have hit the breakpoint is actually reachable. If there are some case statements or if conditions, possibilities are that the line of code is actually missed.

edited Feb 24, 2015 at 16:11

User1000547

4,3219 gold badges44 silver badges68 bronze badges

answered Oct 1, 2013 at 9:52

Dibin

1,5981 gold badge15 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

billinkc Over a year ago

Starting with the 2012 release of SSIS, you do have the ability to debug script components.

Kyle Hale Over a year ago

My first step with the VTSA editor is add a breakpoint at the first line just to get into debug mode and then F5 my way to the actual breakpoint I want.

mhn Over a year ago

Even when i place the breakpoint at the first line, it does not hit the breakpoint. not sure why it does not work now . Already tried the Run64BitRuntime option

Sharmanand Mishra · Accepted Answer · 2013-10-04 03:09:37Z

3

Surely debug is allowed for script task. Couple of point to remember 1. Run the package in 32 bit 2.wherever u set up debug pointer... code should be rechable 3.debug only allowed for 1 script task. Ssis engine can only show you debugging only for 1 script task. If you have 2 script task then ssis will open debugging only for first script task.. suggesting you put de bugging only to one script task

answered Oct 4, 2013 at 3:09

Sharmanand Mishra

692 bronze badges

Comments

Community · Accepted Answer · 2017-05-23 12:09:14Z

0

I ran into this as well and found the script task had been set to optimize code even for debug mode.

See more detail here

edited May 23, 2017 at 12:09

CommunityBot

11 silver badge

answered Feb 22, 2017 at 3:27

Jeff

3521 gold badge3 silver badges11 bronze badges

Collectives™ on Stack Overflow

Not able to debug script task in SSIS

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related