dbTalk Databases Forums  

Debugging DTS Package

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Debugging DTS Package in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
DavidM
 
Posts: n/a

Default Debugging DTS Package - 01-06-2005 , 12:31 PM






Does anyone have any tips for debugging a DTS package?

I've enabled JIT debugging.

It launched Visual Interdev for me to step thru code.

Problem is -- I can't change anything. Guess this is how it works.

When I stop debugging, the debugger stays up but Enterprise Manager closes.

Is this typically? Seems very annoying and takes lots of extra time to
drill down to the package-level again.




Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: Debugging DTS Package - 01-06-2005 , 02:21 PM






In message <#xHEp3B9EHA.1404 (AT) TK2MSFTNGP11 (DOT) phx.gbl>, DavidM
<spam (AT) spam (DOT) net> writes
Quote:
Does anyone have any tips for debugging a DTS package?

I've enabled JIT debugging.

It launched Visual Interdev for me to step thru code.

Problem is -- I can't change anything. Guess this is how it works.

When I stop debugging, the debugger stays up but Enterprise Manager closes.

Is this typically? Seems very annoying and takes lots of extra time to
drill down to the package-level again.

The read-only nature is something I've experienced, but a top tip is to
Detach the debugger, do not Stop, as this leaves EM running.


--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.