I would like to know if there are any reccomodations for the types of drivers to use to conenct to DB2 from SSIS packages, as far as i have understood MS also provides some drivers now for connecting and there are few written by IBM iteself, is there some reccomdation on what to use and when MS drivers: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc IBM drivers are at at the http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0009064.htmAbhinav

i have used HIT OLEDB Server 400 and it worked fine with no issues. Here is the link http://www.hitsw.com/products_services/sql400/oledb400/oledb400svr.html http://sqlworkday.blogspot.com/

Hi, Often, when works with MS products implement MS drivers is better option. My personal recomendation is try first with OLEDB driver developed by Microsoft. In fact, there is one case reported about one bug in IBM OLEDB Driver: http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/eb0bb65e-55d1-445a-b652-0d2d6114dfc5Vctor M. Snchez Garca (ES) (BI) Hope this help. Please vote if you find this posting was helpful. if this is an answer to your question, please mark it. http://bifase.blogspot.com | http://twitter.com/atharky