Debug legacy packages in SQL 2005 workbench -
08-02-2006
, 08:54 AM
Hi-
Is there a way to debug an active-x script task in a legacy DTS package thru
the SQL2005 tools?
In SQL 2000 I used to ensure 'just in time debugging' was ticked and then
could either debug when an error occured or could simply tupe 'stop' in my
code and it would break there.
Is there a way I can get the 2000 tools to do the same, they don't seem to
break on 'stop' when I execute an active-x script task.
Just to be clear I have packages created in SQL 200 but which have been
imported onto a SQL 2005 server and now appear under the 'Legacy' node in
the SQL 2005 management studio.
Cheers,
Jez. |