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. |