A Microsoft SQL server DTS package fails.
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.
SQL server 2000