如何在SSIS中加入两个派生列组件？ [英] How to I join two Derived Column Components in SSIS?

问题描述

我有两个派生列组件，除了一列之外还有不同的列名。

ie。派生列组件1



Column1

Column2

第3栏

Id < br $>








然后



ie。派生栏组件2

栏目4

栏目5

栏目6

Id



两者共有的列是Id;



如何使用合并连接从两个派生列获取数据对象？



我有点想把派生列组件视为相关表格。



谢谢。

I have two Derived Column Components with distinct Column names except one column.
ie. Derived Column Component 1

Column1
Column2
Column 3
Id




And then

ie. Derived Column Component 2
Column 4
Column 5
Column 6
Id

The column that is common to both is the Id;

How can I use a merge join to get data from both derived column Objects?

I kind of, want to treat the derived column compponents as related tables.

Thanks.

推荐答案

http://www.mssqltips.com/sqlservertip/1322/merge-multiple-data-sources-with-sql-server-integration-services/ [ ^ ]



以上链接可能会有所帮助。

http://www.mssqltips.com/sqlservertip/1322/merge-multiple-data-sources-with-sql-server-integration-services/[^]

Above link may be helpful.

这篇关于如何在SSIS中加入两个派生列组件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！