Hi There, I have an excel sheet which has 200 rows of data(number of rows may change from time to time) and the column names always started from second row. i have to create a package which moves the single excel sheet to multiple tables with sometransformations. My package first move the full excel sheet to database next apply transformations on the databse and split it to multiple tables. While reading the excel sheet data into Excel Source iam using sql command select * from [sheet3$A2:K500] actual sheet has only 200 rows of data, but my db is getting all the data rows and null rows from excel. i may change the query to select * from [Created Bugs Raw$A2:K200] but in future the sheet may have 300 rows of data. So, any help in this regard is appreciated. Thanks, Sultan.Srinivas P.

1) IMEX = 1 in the Excel connection string. http://social.msdn.microsoft.com/forums/en-us/netfxbcl/thread/9C9D6A97-0943-4427-B759-963B2B77F7F8 2)TypeGuessRows in resgistry. http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/d0c61e3f-adef-48b8-b14f-abd733a0e952http://deepaksqlmsbusinessintelligence.blogspot.com/ Happy to help! Thanks. Regards and good Wishes, Deepak.

Just add an Conditional Split to your excel source and Build an expression !ISNULL(ColumnName) and this fetch only rows with values. I have a POC if you wanted it lemme know. I you come across any other best solution please share :)

Thanks man, its working fineSrinivas P.

Thanks for your quick reply Deepak. Your help is much appreciated. By the way i'm following your blog http://deepaksqlmsbusinessintelligence.blogspot.com Srinivas P.