We are facing a strange issue with SSIS and thought I would share the same with you and see if there are any solutions. We are developing a solution where users upload their
data in the form of Excel 2007 spreadsheets to a web application interface and then, the file is loaded into an Oracle RDBMS using SSIS 2008 (SSIS called using SSIS Object Model from .NET). Now, there are specific templates provided to the users for their
input files and they are using the same. However, it is being observed that when the user deletes certain rows from Excel manually and tries to load it, the file load fails. The reason for the same
is seen when the package is run in debug mode – the excel source is reading a few rows (we are assuming the recently deleted rows) as NULL values in all the columns. Now, some searching revealed at
http://www.tech-recipes.com/rx/2189/excel_2007_eliminate_blank_rows/ that the following manual set of operations are resolving the problem –
1. Go to the Ribbon, and select the
2. In the
Editing section, click the small arrow next to
Find & Select
Go To Special .
4. Select the
Blanks radio button and click OK.
5. All blank columns/rows will be highlighted.
However, this requires a user intervention and obviously, the users are not really loving it
. I just wanted to check that if there are any po
View Complete Post