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.
Bạn đang xem 5. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P77 PPSX