I had folloing rows in excel 2007 EmpId Ename Sal 1 A 20000 2 B 30000 3 C 22000 4 D 25000 5 E 32000 I want to ignore NULL Values in between 2nd and 3rd records using SSIS 2005.

you Can use conditional split transformation after Excel source to filter the null Rows,

Or use a query with a WHERE CLAUSE that filters NULL: WHERE [Column] not is null Use SQL command instead of Table or view to add a WHERE CLAUSE. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com

In Data access mode select sql command and use the following query select EmpId,Ename,Sal from [sheetname$] where EmpId is not null