Somu, You can import the excel into SSIS, use this method to select your desired rows [http://asqlb.blogspot.com/2011/05/ssis-selective-rows-count-using-script.html][1] then use 4 excel destinations, pointing to your sheets. [1]: http://asqlb.blo...

Somu, You can import the excel into SSIS, use this method to select your desired rows [http://asqlb.blogspot.com/2011/05/ssis-selective-rows-count-using-script.html][1] then use 4 excel destinations, pointing to your sheets. [1]: http://asqlb....

My mistake, sorry top everyone, as Jacob said, i was connecting to a 2005 box not my localhost...thanks for everyone's help. and special thanks to M. Coles for his great script :)...

My mistake, sorry top everyone, as Jacob said, i was connecting to a 2005 box not my localhost...thanks for everyone's help. and special thanks to M. Coles for his great script :)...

Hi Jacob, No actually i'm using 2008R2, but thanks for your thoughts anyway... Thanks Jason...

Hi Jacob, No actually i'm using 2008R2, but thanks for your thoughts anyway... Thanks Jason...

Hi, Why I'm getting all these errors when I try to use your query above? Msg 139, Level 15, State 1, Line 0 Cannot assign a default value to a local variable. Msg 137, Level 15, State 2, Line 9 Must declare the scalar variable "@input". Msg 137, Le...

Hi, Why I'm getting all these errors when I try to use your query above? Msg 139, Level 15, State 1, Line 0 Cannot assign a default value to a local variable. Msg 137, Level 15, State 2, Line 9 Must declare the scalar variable "@input". Msg 137,...