what is the difference between OLEDB Destination and SQL server Destination in SSIS

what is the difference between OLEDB Destination and SQL server Destination in SSIS all here: http://consultingblogs.emc.com/jamiethomson/archive/2006/08/14/SSIS_3A00_-Destination-Adapter-Comparison.aspx Note that is an old article and suggests using SQL Server Dwstination may be the better choice in certain scenarios. *Ignore that advice*. Changes have since been made to SSIS which mean there is no longer any scenario where using the SQL Server Destination is advantageous - do not use it. http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

also here is similar thread http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9f9208ad-6371-4cdf-aed4-778b8b7eea4c/ http://uk.linkedin.com/in/ramjaddu