Previous Topic Next topic Print topic


Transfer Data Tool Error Messages

This topic describes the error messages that are related to the Transfer Data tool.

Error Message Description or Cause Resolution
A shared task cannot have a local transfer list A shared task must associate a shared transfer list. Make sure the shared radio button is checked for the transfer list.
A wrong row is selected A wrong row is selected when updating the customization. Make sure the last changed row is selected/highlighted.
Connection failed Source or destination connection failed. Make sure the user ID and password correct.
Deletion result: Failure The user does not have the permission of DELETE for the table or database. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user permission of DELETE.
(DSN’s provider) is not an OLE DB Provider The underlying database provider is not of OLE DB type. Recreate the DSN using the recommended Microsoft OLE DB provider.
Error in writing to file Error in writing a task to XML file. Check the task name and path for illegal characters.
File Access Violation Either READ or WRITE permission is not granted to the user. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user file access.
Invalid command line parameter The specified parameter value is empty or out of range. Assign a proper value to the parameter.
Invalid Data Source Name The name of the data source or data destination is empty. Add the name of the data source or data destination to the command line argument.
Invalid number of arguments The command line has no arguments. Add the required arguments to the command line.
Invalid target object list Syntax error. There is no “=” operator. Add an “=” operator.
No query is selected for customization An action button is clicked before a row of query is selected for customization. Make sure the row is highlighted first.
No task name is set No task name is set on GUI. Select the desired task name on GUI.
SSIS package execution result: Failure Data in the source database is not accessible. Data type mapping is incompatible. Make sure the data accessible for SELECT statement. Check the version of SQL Server Native Client provider. It should be 10.x or above.
SSIS package validation result: Failure Either the source or destination connection fails. Check the connection(s).
Target table does not exist The target table in the destination database has not been created. Create the table in the destination database.
The destination DSN is not found The destination DSN is not set or it is not defined. Specify an existing connection or create one if the connection you want to use does not exist.
The process does not have the READ permission to the file The process does not have READ permission to the specific file. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user READ permission.
The process does not have the WRITE permission to the file The process does not have WRITE permission to the specific file. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user WRITE permission.
The source DSN is not found The source DSN is not set, or it is not defined. Set the source DSN or create one if it does not exist.
The transfer list is not found in the directory The transfer task file does not exist in the specified path. Make sure the specified file exists in the path; and the file name is correct.
There is no object list file in the location No transfer list files in the specified “local” or “shared” folder. Run through Define List tool again.
There is no table in the Data Transfer list The data transfer task file contains no tables. Add the desired tables to the task file.
Unable to read list file Unable to read the transfer list file. Depending on the security policy of the organization, the resolution can be either Run as Administrator or Grant the user READ permission on the file.
Validation of command line parameters failed Some of the command line parameters have syntax errors. Correct the syntax errors by following the required format.
Workflow Error The workflow is not in correct order. Make sure the workflow in correct order.
Previous Topic Next topic Print topic