Troubleshooting Data Transformation Services

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

• When using DTS on Alpha platforms, the Microsoft OLE DB Provider for Jet, supplied by default with Microsoft® SQL Server™, works when configuring connections to Microsoft Access. However, the ISAM components needed to make connections between that provider and data sources such as Microsoft Excel, Paradox, and dBase files are not installed. If you try to configure any of these data sources on an Alpha computer, you will receive an error message.
• 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 stream cannot be detected.