![]() ![]() For more info, see Column Conversion Details Dialog Box. The Column Conversion Details dialog box opens and displays more detailed conversion information for the column. To see detailed information about the conversion of a particular column of data, double-click any row in the list. Fail with an error, and stop the import or export process Use the On Truncation (global) setting, which you can specify at the bottom of this page. Specify how the wizard handles truncation: Fail with an error, and stop the import or export process. Use the On Error (global) setting, which you can specify at the bottom of this page. Clear the check box to cancel the data type conversion. Select the check box to have the wizard continue with the planned conversion. Specify whether to continue with the planned conversion: A red error icon indicates that the wizard is not able to perform the conversion reliably. To review the conversion, double-click on the column to view the Column Conversion Details dialog box. A yellow warning icon indicates that you should review the conversion that the wizard will perform. A green check mark icon indicates that the wizard expects the data type conversion for this column to succeed. The following table describes the columns in the Data type mapping list. The warning icon on the first row in the Data type mapping list indicates that the mapping from the int data type of the source column to the smalldatetime data type of the destination column may cause a loss of data. In this example, each column at the source will be copied to a column with the same name and data type at the destination. This grid provides detailed conversion information about the columns in the source table that's selected in the Table list in the upper part of the page. ![]() The middle section of the Review Data Type Mapping page is the Data type mapping list. A table icon with a sunburst indicates that the destination is a new table that the wizard will create. A table icon indicates that the destination is an existing table. Indicates whether the destination already exists or will be created by the wizard: A red error icon indicates that the wizard is not able to perform some of the conversions for this table reliably. To review these conversions, select the table, and then review the conversions for individual columns in the Data type mapping list. A yellow warning icon indicates that you should review the individual conversions that the wizard will perform. A green check mark icon indicates that the wizard expects all data type conversions for this table to succeed. Indicates the probability of success for the data type conversions: The following table describes the columns in the Table list. The warning icon indicates that there is a problem converting at least one column of data from the query results to a compatible data type in the destination table. In this example, the results of the query that the user provided will be copied to the Sales.CustomerNew2 table at the destination. The conversion information for the individual columns of the selected table appears in the lower part of the page in the Data type mapping grid. To see conversion information about an individual table, select a table in the Table list. The upper section of the Review Data Type Mapping page is a Table list that lists the tables to be copied from the source to the destination. The warning icon on the first row in the Data type mapping list indicates that the mapping from the int data type of the source column to the smalldatetime data type of the destination column may cause a loss of data.The warning icon on the row in the Table list indicates that there is a problem converting at least one column of data from the query results to a compatible data type in the destination table.The user has specified a mapping in the Column Mappings dialog box that may not succeed.The following screen shot shows an example of the Review Data Type Mapping page of the wizard. Screen shot of the Review Data Type Mapping page To take another look at the Column Mappings dialog box, see Column Mappings. ![]() In the Column Mappings dialog box, you can specify data type mappings that are more likely to succeed. However, you can click Back to return to the Select Source Tables and Views page, and then click Edit Mappings to open the Column Mappings dialog box again. You can't change data type mappings on the Review Data Type Mapping page. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |