I'm trying to use SSIS to import tables from an Oracle DB. The Import Wizard can connect to the Oracle db successfully, but I get the following errors when I try to select the tables and views. I can modify the field types manually, but there must be a better way of handling this. Any suggestions?

Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider.

"FMC_ACTIVITY_TYPES" -> [dbo].[FMC_ACTIVITY_TYPES]:

- The data type could not be assigned to the column "NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "TEXT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "TEXT_NATIONAL" in "SQL Server Native Client 10.0".

"FMC_AREAS" -> [dbo].[FMC_AREAS]:

- The data type could not be assigned to the column "POLYGON" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_AREA_TYPE_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "DESCRIPTION" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_NATION_CODE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "POLYGON_AS_CLOB" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VALID_YN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "HARBOUR_CODE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "INCLUDED_IN_ELB_YN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "ICES_AREA_CODE" in "SQL Server Native Client 10.0".

"FMC_AREAS_V" -> [dbo].[FMC_AREAS_V]:

- The data type could not be assigned to the column "NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "POLYGON" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "POINT_BUFFER_KM" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_AREA_TYPE_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "DESCRIPTION" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_NATION_CODE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_SCENARIO_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VALID_YN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "POINT_YN" in "SQL Server Native Client 10.0".

"FMC_HAIL_CATCH" -> [dbo].[FMC_HAIL_CATCH]:

- The data type could not be assigned to the column "SPECIES_CODE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "CATCH_CAT_CODE" in "SQL Server Native Client 10.0".

"FMC_HAIL_MESSAGES" -> [dbo].[FMC_HAIL_MESSAGES]:

- The data type could not be assigned to the column "PORT_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_COASTAL_NATION" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "MASTER_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VES_IDENT_TRANS_FROM" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VES_IDENT_TRANS_TO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "CREATOR_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_SUBSCRIBER_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "DIRECTED_SPECIES" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_CHARTERING_FLAG" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "RN_OR_SQ" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "OBSERVER_ONBOARD" in "SQL Server Native Client 10.0".

"FMC_HAIL_MESSAGES_GUI_V" -> [dbo].[FMC_HAIL_MESSAGES_GUI_V]:

- The data type could not be assigned to the column "PORT_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_COASTAL_NATION" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "CREATOR_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_SUBSCRIBER_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "DIRECTED_SPECIES" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VES_IDENT_TRANS_FROM" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VES_IDENT_TRANS_TO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "MASTER_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "OBSERVER_ONBOARD" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "CATCH_YN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "COB_YN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "LAT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "LON" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_STATUS_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "AREAS" in "SQL Server Native Client 10.0".

"FMC_IN_NAF_PARSED_V" -> [dbo].[FMC_IN_NAF_PARSED_V]:

- The data type could not be assigned to the column "RAW_DATA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "RECEIVED_FROM" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_AD" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_FR" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RD" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_SQ" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TM" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RC" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_IR" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_XR" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_NA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_FS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_MA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_CS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_PO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_PD" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_PT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_KG" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_OB" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_CA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_DS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RJ" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_US" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_DF" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TF" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_LA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_LO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_LT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_LG" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_CO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_SP" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_ON" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_MS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_ME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_PR" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_LB" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_HA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_AF" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TP" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_VO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_VC" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_GE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_VT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_VL" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_VP" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_LU" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_IS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_SD" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_ED" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RR" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_SN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_ZO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_CC" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_YM" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_MI" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_AI" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_OS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_OI" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_IV" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_AC" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_PH" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_DA" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TI" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_AP" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_CD" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_FO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_NE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_NU" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_QP" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_RQ" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TU" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "L_TY" in "SQL Server Native Client 10.0".

"FMC_OBS_CATCH" -> [dbo].[FMC_OBS_CATCH]:

- The data type could not be assigned to the column "SPECIES_CODE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "CATCH_CAT_CODE" in "SQL Server Native Client 10.0".

"FMC_VESSELS" -> [dbo].[FMC_VESSELS]:

- The data type could not be assigned to the column "EU_IDENT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "COMMENTS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "IMO_NUMBER" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "AUTO_MAINTAIN_YN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "CHANNEL_USED" in "SQL Server Native Client 10.0".

"FMC_VESSELS_V" -> [dbo].[FMC_VESSELS_V]:

- The data type could not be assigned to the column "EU_IDENT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "IMO_NUMBER" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_NATION_CODE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VISIBLE_IDENT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VESSEL_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VESSEL_SYMBOL" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "INM_C_NUMBER" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "RADIO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "RADIO2" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_TRANSTYP_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VESSEL_TYPE_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "HOME_PORT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "EMAIL" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "EMAIL2" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "COMMENTS" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "SECTOR" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "DECLARATION_CODE" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "VESSEL_TXT" in "SQL Server Native Client 10.0".

"FMC_VESSEL_DETAILS" -> [dbo].[FMC_VESSEL_DETAILS]:

- The data type could not be assigned to the column "INM_C_NUMBER" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "RADIO" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "FMC_TRANSTYP_NAME" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "HOME_PORT" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "ICCAT_ID" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "NATIONAL_ID" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "EMAIL" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "EMAIL2" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "SERIAL_NUMBER" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "ISN" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "ELB_INM_C_NUMBER" in "SQL Server Native Client 10.0". - The data type could not be assigned to the column "RADIO2" in "SQL Server Native Client 10.0".

It is not all columns, only those mentioned in the error. There are several that are not mentioned, so I'm assuming there is no problem with those. Many of those listed appear to be VARCHAR2, which is specific to Oracle, so I suspect you are correct about the data types causing the problem. Is there a way to define what they should be changed to, without addressing every field listed?