Skip blank rows in Excel spreadsheet when importing 1

[elsenorjose]

Hello everyone,

I have a very simple import package that imports an Excel spreadsheet and appends the values to a table. The problem is that the spreadsheet is created by an application that always creates a blank row every other row. So after the column headers in row 1, row 2 is blank, row 3 has data, row 4 is blank, etc. etc. Is there a way to have the package script ignore blank rows during the import?

Thank you

 

[dhulbert]

Put a conditional split betwen your data source and your destination and filter out the null rows.

Nice and easy.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[elsenorjose]

Hi, thanks for the reply. What is a 'conditional split'?

 

[NiceArms]

http://redmondmag.com/articles/2010/04/26/ssis-conditional-split.aspx

or

http://www.bimonkey.com/2009/06/the-conditional-split-transformation/

should get you started.

I feel sorry for people who don't drink, when they wake up in the morning that's as good as the're going to feel all day!

 

[elsenorjose]

Thanks for the links!