.csv加载,目标表有多行而不是源 [英] .csv load, target table has more rows than source
问题描述
这很奇怪,我已将一系列.csv文件加载到一个sql server表中,每个文件属于一个月中的某一天
this is weird, I have loaded a series of .csv files into one sql server table, each file belongs to one day of the month
所以当我检查时计算其中一天,目标表的行数多于源csv文件
so when i check the counts for one of the days, the target table has more rows than the source csv file
1。如何找出目标表有更多行的原因
1. how to find out why target table has more rows
2。在csv中,一切都是文本,现在我的表甚至将日期列作为char,我可以在目标表中使用日期列
2. in csv, everything is text, right now my table has even date columns as char, can i have date columns in my target table
从csv加载时
推荐答案
   您是否检查了差异,哪些行是额外的和多少?
Did you check the difference, which rows are extra and how many?
还检查这些额外的行是否具有所有值?
Also check if those extra rows have all the values ?
我相信一些新行导致问题,可能需要处理。
I believe some New line is causing the issue and may need to be handled.
这篇关于.csv加载,目标表有多行而不是源的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!