Post reply

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

  • 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 ?

     

     

  • 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.

     

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • 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.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply