Troubleshooting Data Transformation Services

Note  For immediate help in diagnosing your Data Transformation Services (DTS) problems, see the new online troubleshooter on the Product Support Web site. For more information, see Help with Data Transformation Services.

Following is information about errors that might be generated while using DTS Designer:

• If a connection is created for a database user who does not have permission to access the model database, when opening the transformation properties, the user will receive the message "Unspecified error. Server user '<user name>' is not a valid user in database 'model'". This message occurs because the user cannot see the provider type information. However, the error is informational and does not prevent the user from creating the transformations.

If you receive the message "Cannot find the specified file," when attempting to access a DTS package saved to a COM-structured storage file, verify that:

• The directory path is specified correctly.
  
  
• Permissions are set correctly.

Note  It is possible that the file is corrupt and that the COM structure cannot be detected.