Migrating From DB2 to SQL using SSIS RRS feed

  • 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/
    Thursday, November 11, 2010 2:40 PM


All replies