将数据从Oracle导入SQL Server。
我在Oracle（12g）中有一个包含193M行的表，我试图将其导入SQL Server数据库。我正在尝试使用SQL Server导入/导出向导，但导入整个表的选项不可用。我也在考虑使用SSIS。有
其他人是否有过这个过程的经验？
I have a table in Oracle (12g) with 193M rows that I am trying to import into a SQL Server database. I am trying to use the SQL Server Import/Export Wizard but the option to import the entire table is unavailable. I am also thinking about using SSIS. Has anyone else had any experience with this process?
https ：//blogs.msdn.microsoft.com/sqlperf/2009/08/14/using-ssis-to-get-data-out-of-oracle-a-big-surprise/
https://blogs.msdn.microsoft.com/sqlperf/2009/08/14/using-ssis-to-get-data-out-of-oracle-a-big-surprise/
OLEDB目的地具有"快速负载"。选项，不要忘记选择它
OLEDB Destination has "fast load" option, do not forget to select it