A while ago I read this MSDN Blog post that stated that (short version) OLE DB is outdated and we should all use ODBC again. SQL 2012 will be the last release to support OLE DB. Should we all start using ODBC in SSIS?
|To OLE DB or not to OLE DB?|
Today, at the Dutch SQL saturdays, I had the change to ask that question to some of the brightest SQL people from The Netherlands (a Microsoft Certified Master and a couple of Microsoft Premier Field Engineers). Their answer: ODBC will become the standard in the future versions, but at the moment (SQL 2012) OLE DB is still much faster! So use OLE DB where possible.
Besides that... a lot of components (like the lookup) only support OLEDB. See complete list here.