Establishing why a DTS package has failed

Version 2
    Question

    A Microsoft SQL server DTS package fails.

    Answer

    Generally, If a DTS package fails, the following steps assist in troubleshooting:

     

    1.  In Enterprise Manager, Expand Data Transformation Services and select 'Local Packages'

    2.  Right click the package that failed and select 'Package Logs'

    3.  Select the latest log in the list and click 'Open Log'

    4.  Highlight the failed row and click the view error button.

    Environment

    SQL server 2000