OLEDB目标未插入从excel导入的完整记录 [英] OLEDB destination not getting inserted with full records imported from excel
问题描述
大家好,
我要求从excel源导入记录。我错误地重定向了行并有后续任务。但是,完整的记录没有插入到目的地。我已经使用数据查看器验证了记录
到达OLEDB目的地(SQL服务器)。
I have a requirement in which im importing records from excel source. I have redirected rows on error and having a subsequent task. But, the full records are not getting inserted into destination. I have verified using data viewer that the records are coming till OLEDB destination (SQL server).
EG:我在源代码中有609条记录。 609条记录即将到达oledb目的地,但只有600条记录被插入。没有记录重定向到错误输出。附上截图供参考。请帮助。
EG: I have 609 records in source. 609 records are coming till oledb destination but only 600 records getting inserted. No records redirected to error output. Attaching a screenshot for reference. Please help.
谢谢,
Vikram
Vikram
推荐答案
是否可能有一个带有选项"Ignore dup key"的唯一索引。在桌子上和缺少的9行违反了uniqness?
Is there may be an unique index with option "Ignore dup key" on the table and the missing 9 rows violate the uniqness?
这篇关于OLEDB目标未插入从excel导入的完整记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!