How to make ssis package to read data from db2 and insert to sql serve

• ahmed_elbarbary.2010

  Hall of Fame

  Points: 3118

  More actions

  August 10, 2023 at 7:39 am

  #4257494

  I have two servers one server have sql server database and another server have db2 database

  I need to read data from db2 database on server A  then after read it insert it into sql server database that exist on server B

  I use sql server 2017

  so can you give me How to create ssis package to make that by details

  I not working on ssis package before so if you can give me answer by more details will be better ?

   

   

  • This topic was modified 1 year, 9 months ago by  ahmed_elbarbary.2010.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  August 10, 2023 at 7:55 am

  #4257497

  Getting started with SSIS is a bit of a learning curve. I recommend you read a few of the stairway articles (link) to help you understand how everything fits together.

  But here is the overall pattern at its simplest:

  • Create a solution in VS
  • Create an Integration Services project inside the solution
  • Create a package inside the project
  • Create two connections in the package: one to your DB2 database and one to your SQL server database.
  • Create a dataflow in your package.
  • Add a source and a target to the dataflow. The source references the DB2 connection and the target references the SQL Server connection.
  • Execute the package.

   

  ---

• komal145

  SSCrazy Eights

  Points: 9920

  More actions

  August 15, 2023 at 2:55 pm

  #4261829

  For DB2 connection , you need to set a odbc connection. Install db2 drivers first on sql server set up.

  You need to set up/Create the node for db2.