How to map IDs in different formats from source to destination

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

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.
1,839 questions
No comments
{count} votes

1 answer

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

    Check these for more:

    Integration Services Data Types

    Working with SSIS Data Types


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

    No comments