In destination access table, one column is Yes/No type while there is no yes/no datatype in Sql server. Int datatype is employed where 0 indicates false and –1 indicates true.
Also in access, all varchar datatype is Unicode WT_WSTR while in Sql server, they are DT_STR. Need to use derived columns between source and target just to convert them.
No comments:
Post a Comment