Dear All, I am new to the DB2 and SSIS.as i want to conncet DB2 with SSIS for loading table from DB2. please let me know the steps of same. i installed DB2 Client on my system . what to do next and what to install. regards, Vipin jha

You need to create the connection via the ODBC admnistraotr window. Withere get the catalouge uncalataluge commands from the DBA, or create it via the adminstrator, but you need to know the source server, database, node to connectAbhinav

If you have SQL Server Enterprise edition, you can install the Microsoft OLE DB provider for DB2. Very easy to use in SSIS: you just create an OLE DB connection manager, enter the server and credentials and you're done. http://www.microsoft.com/en-us/download/details.aspx?id=16978MCTS, MCITP - Please mark posts as answered where appropriate.

Hi Vipin jha, After you install the Microsoft OLE DB Provider for DB2 using the link Koen provided, create a connection manager in your package just like you normally would and select the Microsoft OLE DB Provider for DB2 from the list of available drivers, for step by step details, please refer to: Connecting to DB2 from SSIS: http://geekswithblogs.net/13DaysaWeek/archive/2010/05/16/connecting-to-db2-from-ssis.aspx Thanks, Eileen