what is the difference between oledb command and excute sql task can any give me the differences

OLEDB command will always process data row by row, wheras execute SQL task if you call an Stroed procedure it can process data in bulk MOre so one is contrl flow task and one is data flow, effectivley i dont understand why you want to compare the 2, they are differentAbhinav

what is the difference between oledb command and excute sql task can any give me the differences One is in the Data Flow, one is in the Control Flow. If that doesn't help to answer your question then I suggest you spend some time understanding the difference between the Data Flow and the Control Flow.ObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

oledb command can do row by row performence, execute sql task can do sql statement like procedure execute sql task is batter than oledb command

oledb command can do row by row performence, execute sql task can do sql statement like procedure execute sql task is batter than oledb command Hi Laxman, Good answer, although I take issue with the statement "execute sql task is batter than oledb command". Some people might say "a motorbike is better than a car" but that's not the case if the thing you want to do is transport some boxes. The point is, your choice of whether to use the Execute SQL Task or OLE DB Command depends on what you want to achieve, it is not proper to describe one as being better than the other. Just my opinion. JTObjectStorageHelper<T> A WinRT utility for Windows 8 | http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

Yeah you are right Jamie, it depends on the requirement. i strongly agree with you