Migrating From DB2 to SQL using SSIS

Question

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 Regards

---

Abhay Chaudhary OCP 9i, MCTS/MCITP (SQL Server 2005, 2008, 2005 BI) ms-abhay.blogspot.com/

Answer 1

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=932264786

---

http://www.rad.pasfu.com

Answer 2

There is a good guide MigrateDB2toSQLServer_2009.pdf from download.microsoft.com

---

Arthur My Blog

Answer 3

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 Chen

---

Jin Chen - MSFT