如何在插入之前从Destination获取值？ [英] How to get the value from Destination before inserting?

问题描述

我是SSIS的新手。目前正致力于将数据从SQL迁移到Oracle。我们在两个数据库中都有表（具有不同的数据类型）。比如，一个主人（角色）和一个孩子（员工）。我正在将Employee表从SQL迁移到Oracle。 RoleID是
Employee表中的FK。

由于目标表数据类型&值与Source不同，我需要使用"RoleName"从Destination表中获取相应的RoleId。在目标中插入所有Employee数据之前从Source员工表。

Source：  Employee Table - > RoleId（GUID数据类型）

Destination   Employee Table - > RoleId（Int数据类型）

任何想法如何实现这一目标？在此先感谢。

解决方案

目前还不完全清楚（你可以看到我们不能的结构），不过我建议你将表从SQL转移到Oracle，并在Oracle中更改/检查相应的RoleId。 

I am new to SSIS. Currently working on migrating data from SQL to Oracle. We have tables in both the databases (with different Datatypes). Say, one master (Roles) and one child (Employee). I am migrating Employee table from SQL to Oracle. RoleID is the FK in Employee table.

Since the destination table datatype & values are different from Source, I need to get the corresponding RoleId from Destination table using "RoleName" from Source employee table before inserting all the Employee data in Destination.

Source: Employee Table --> RoleId (GUID Datatype)

Destination Employee Table --> RoleId (Int Datatype)

Any idea how to achieve this? Thanks in advance.

解决方案

It is not totally clear (you can see the structure we can't), however I would recommend you to transfer the table from SQL to Oracle as it is and to work out in Oracle to change/check the corresponding RoleId. 

这篇关于如何在插入之前从Destination获取值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！