SSIS不会插入所有行 [英] SSIS is not inserting all rows

问题描述

我遇到 VS SSDT 2017 SSIS Express Edition 的问题.我的源是Oracle 12G，目标是SQL Server 2017.源连接和目标连接.数据来自SQL脚本.使用OLE DB连接.在源中计数为238674行，但SSIS只能加载并插入144254行，并且没有任何错误.程序包以成功结束(绿色复选标记).目标表没有类型或其他问题.所有类型和大小均与来源相同.当我从SQL脚本中删除大多数列并仅加载1或2列时，它将提取并插入所有238674行.但是，当列数更多(8到9列)时，插入的行数就会变小.

I have an issue with VS SSDT 2017, SSIS Express Edition. My Source is Oracle 12G and Destination is SQL Server 2017. My package consist of simple Data Load task; Source Connection and Destination connection. And data is coming from SQL script. Using OLE DB connection. Count in source says 238674 rows but SSIS loads and inserts only 144254 rows and there is no any error. Package ends with success (green check marks). Destination table has no issues with types or something. All types and sizes are identical with source. When I delete most of the columns from SQL script and load only 1 or 2 columns it extracts and inserts all 238674 rows. But when there are more columns (8-9 columns), inserted row number is getting smaller.

推荐答案

我能够通过以下方式解决此问题:1.以管理员身份打开SSDT2.使用ODBC Source(32位)进行Oracle Source连接3.使用SQL Server Destination进行MSSQL 2017连接

I was able to solve this issue by this way: 1. Open SSDT as Administrator 2. Use ODBC Source (32bit) for Oracle Source connection 3. Use SQL Server Destination for MSSQL 2017 connection

在这种情况下，一切正常.

Everything works fine in this case.

这篇关于SSIS不会插入所有行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！