REVIEW DATA TYPE MAPPINGS. THERE MAY BE SOME ISSUES WITH THE DATA T...

5. Review Data Type Mappings. There may be some issues with the data types

used for the source and destination columns. If there is, the wizard will

show you the Review Data Type Mappings page. It will flag the tables and

columns that have problems with a warning icon if there are mapping issues.

Where the data types don’t match, you may want to go back and

review the options you selected in the wizard to make sure that you are

mapping the right source columns to the right destination columns. If the

source is a flat file, you can also use the advanced properties on the data

source to indicate the correct data types to use as it pulls data from the

source file.

You can also use the Review Data Type Mapping page to specify how

the import process should deal with errors that occur. You can choose to

ignore the error (which probably means you will get a null for the value

that was invalid), or you could choose to have the error fail the package.

You can set global responses for both errors and truncations (the data in

the source is too large for the destination). You can also set the error han-

dling specifically for each column if needed.