Share via

SSIS lookup into other table

K P 61 Reputation points
2021-06-23T18:57:42.45+00:00

I am moving data from oracle to sql. In oracle the "created_by" column has user name, when i move to sql i want to find the id from user table and insert user id in sql's table. How do i do that ?

Thank you,
Kp

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
0 comments
Accepted answer
  1. Jeffrey Williams 1,896 Reputation points
    2021-06-23T20:58:34.793+00:00

    You can use a LOOKUP in SSIS - or you can load the data to a staging table and join to the user table.

    2 people found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2021-06-24T01:48:49.637+00:00

    Hi @K P ,

    Please also refer Query database which has provide 3 methods.

    It has provided some detail steps I think is useful to resolve your issue.

    Regards，

    Zoe

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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October

    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.