Help with Data Transformation Services

Troubleshooting SQL Server

Troubleshooting

Help with Data Transformation Services

The online Data Transformation Services Troubleshooter is designed to help you resolve problems you may encounter with Data Transformation Services (DTS) in Microsoft® SQL Server™ 2000.

Note  For international users of SQL Server Books Online, the text of the problems as well as the references to Knowledge Base articles appear in English so that this information can be found on nonlocalized Web sites.

Common starting points for troubleshooting DTS include:

  • I'm having a problem using DTS Designer or a wizard to create a DTS package.

  • I'm having a problem executing a scheduled package.

  • I'm having a problem executing a package that isn't scheduled.

  • My DTS package takes a long time to complete.

  • My DTS package takes a long time to stop running after it fails or is canceled.

To access troubleshooters online, see Viewing Online Troubleshooters and other PSS Web-Based Information.