How to map IDs in different formats from source to destination

Ana Alves 1 Reputation point
2020-08-20T14:11:24.923+00:00

Hi,
My source data is in postgreSQL and my target data is in Common Data Service (D365).
On source, I have employees with these IDs:

  • 1
  • 2
  • ...

On target, the IDs are a little bit more complex.
How can I map these IDs? I need to know that the employee with the Id 1 (source) corresponds to the worker with the Id b15a1bd9-50e2-ea11-a81b-000d3a33f94a (target).
PS: I can't edit the source database.

I appreciate your help.

Best regards,
Ana Alves.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Cris Zhan-MSFT 6,606 Reputation points
    2020-08-21T10:35:06.083+00:00

    Hi,
    Check these for more:

    Integration Services Data Types

    Working with SSIS Data Types

    ===============================================

    If the response helped, do "Accept Answer" and upvote it.

    0 comments