But when I click Refresh in the OLE DB Command I get the following error message;
Error at Data Flow Task [OLE DB Command ]: SSIS Error Code DTS_E_OLEDBERROR. AN OLE DB error has occurred. Error code 0x80040E30.An OLE DB record is available. Source "Microsoft OLE DB Provider for Oracle" Hrsult: 0x80040E30 Description: "Type name is invalid.".Error at Data Flow Task [OLE DB Command ]: Unable to retrieve destination column descriptions from the parameters of the SQL command.