November 4, 2004 at 9:55 am
Hi ,
Can somebody please tell me as to what is the best and effecient way to debug a DTS package.
November 4, 2004 at 11:57 am
Start by opening the package in DTS Designer and executing each step individually. Also, enable package logging and, if you're using Transform Data tasks, enable logging for the tasks.
Greg
Greg
November 5, 2004 at 2:00 am
This is a "DOH!" error that happened to me...
When you run the tasks individually within the designer, you're taking reponsibility for the workflow. I guess this is obvious, but it can disguise bugs caused by the workflow being wrong. You end up with a package which will work from the designer but not outside.
For instance, if you have two or more workflow lines (or transformations) from one task or connection node, some can end up either with the wrong predecessor or none at all. Worth checking by right-clicking the workflow line and choosing workflow properties.
Bill.
November 5, 2004 at 7:24 am
What is it that you are trying to debug in the package? You can debug the vba bits by inserting a stop statement where you want to start debugging. Make sure that you set the option for just in time debugging by right clicking on the data transformation services node in enterprise manager and selecting properties.
November 5, 2004 at 8:04 am
Turn on Just in Time debugging option -
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply