来自Excel空行的SSIS数据流 [英] SSIS Dataflow From Excel Empty Rows

问题描述

我正在使用SSIS数据流将数据导入SQL2008.

I am using SSIS Dataflow to import data into SQL2008.

我的数据源是一个excel文件.

My data source is an excel file.

数据流正在运行，但是似乎它正在从Excel文件导入空行.我不明白为什么会这样.

The dataflow is working, however it seems that it is importing empty rows from the Excel file. I don't understand why this is happening.

例如，我在第1行到100,000行中有数据.但是当数据流任务运行时，它可能会说它正在导入200,000行.

For example i have data in rows 1 to rows 100,000. But when the data flow task runs it might say it is importing 200,000 rows.

然后将数据导入到excel中时，我得到200,000行数据，并且在数据之间有100,000空行.

When I then import the data back into excel, I get 200,000 rows of data with 100,000 empty rows in between the data.

有人可以帮忙吗?

谢谢

推荐答案

Excel众所周知，将空行保留在曾经存在但已被删除的行中的任何地方都是不好的.也许这是你的问题.

Well Excel is notoriously bad for leaving empty rows anywhere that rows used to exist but were deleted. Maybe this is your problem.

您可能会考虑在数据流中执行条件拆分任务，该任务会丢弃列为空的任何行

You might consider a conditional split task in the data flow that throws away any rows where the columns are empty

这篇关于来自Excel空行的SSIS数据流的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！