Hi SSIS Experts , This is really very urgent and I have been posting the same question in different forums ....Not much help I could get ... We have a project where we need to move from Mainframe DB2 to SQL Server 2008. I am suggesting using SSIS to extract the Data and insert into SQL Server 2008 R2 However, I am not very sure what all Providers I might be needing to get the data from DB2 .Secondly , Is my bet on SSIS good enough ..if yes what should be my approach to migrate the data from DB2 to SQL using SSIS ....We only have tables and views ... Any help is greatly appreciated .. Best RegardsAbhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/

you can , look at these links: http://www.bidn.com/blogs/PatrickLeBlanc/ssis/700/connecting-to-db2-using-ssis http://mindyourbiz.spaces.live.com/blog/cns!C0081443F3A8BD8D!199.entry?sa=932264786http://www.rad.pasfu.com

There is a good guide MigrateDB2toSQLServer_2009.pdf from download.microsoft.comArthur My Blog

Just add to Arthur's response, the link is: http://download.microsoft.com/download/C/0/C/C0C8C15A-32AD-418E-85BF-A6FF0CCE052C/MigrateDB2toSQLServer_2009.pdf Thanks, Jin ChenJin Chen - MSFT