Share via

Load data from db2 and insert to SQL server

mcdown0828 120 Reputation points
2023-08-30T13:17:43.4266667+00:00

Is it possible to load data from DB2 to sql server?

I can not see the DB2 source when creating the packages.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 41,491 Reputation points
    2023-08-31T01:42:19.73+00:00

    Hi @mcdown0828,

    You may use ODBC to connect to DB2 and then load data to sql server database.

    Check Connect to DB2 database from SQL Server Integration Server for detail steps.

    Regards，

    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 Reputation points
    2023-08-31T08:08:05.02+00:00

    I can not see the DB2 source

    Why do you expect a DB2 specific datasource; there is none?

    Use the common OleDB or ODBC connector together wir DB2 data provider.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.