debug DTS package

  • Hi ,

    Can somebody please tell me as to what is the best and effecient way to debug a DTS package.

     

     

  • 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

  • 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.

  • 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.

  • Turn on Just in Time debugging option -

    1. In the SQL Server Enterprise Manager console tree, right-click the Data Transformation Services node, and then click Properties.
    2. Select the Turn on just-in-time debugging check box.

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply