Hi All, Can anyone provide me the steps for fetching the data with IBM DB2 database with the help of SSIS.We have two different servers with DB2 database and SQL database. Thanks in advance, ChandanThanks Chandan

Is it AS400? You need to download specific provider to connect to as400 database.Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hello Chandan, If you are using SQL Server 2005 then you can download Microsoft OLEDB Provider for DB2 from the Feature Pack for Microsoft SQL Server 2005 The Microsoft OLE DB Provider for DB2 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2005 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with SQL Server Integration Services, SQL Server Analysis Services, Replication, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the provider and tools on both x86 and x64 computers. Read the installation guide and Readme for more information. If you are using SQL Server 2008 then you can download Microsoft OLEDB Provider for DB2 from the Feature Pack for Microsoft SQL Server 2008 The Microsoft OLE DB Provider for DB2 version 2.0 is a COM component for integrating vital data stored in IBM DB2 databases with new solutions based on Microsoft SQL Server 2008 Enterprise Edition and Developer Edition. SQL Server developers and administrators can use the provider with Integration Services, Analysis Services, Replication, Reporting Services, and Distributed Query Processor. Run the self-extracting download package to create an installation folder. The single setup program will install the version 2.0 provider and tools on x86, x64, and IA64 computers. Read the installation guide and Readme for more information Hope that Helps! Thanks Ashish Kumar Mehta Please click the Mark as Answer button if a post solves your problem!

Hi, Simply use the Microsoft OLEDB provider for DB2, is the faster one. http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/cfade7e7-50d5-4447-9821-35c5d5ae1b66 Víctor M. Sánchez García (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