SSIS数据流 - 带有所需外键值的顺序插入 [英] SSIS Data Flow - sequential insert with required foreign key values

问题描述

是否可以插入初始表，然后使用插入的ID插入到主表中，该主表在一个数据流中的列之间具有外键约束？



我是集成服务的新手，不知道能力



场景：



表A - ID - DESC



表B - ID - A_ID - DESC



这个是A_ID是外键的地方（如果不明显的话）



我可以用这种连续的事件流创建单个数据流，还是我需要创建插入表A后插入表B的另一个数据流。

Is it possible to insert to a initial table then using the inserted ID to be used in inserting to the main table that has a foreign key constraint between the columns in one data flow?

I am new to integration services and don't know the capabilities

Scenario:

TABLE A - ID - DESC

TABLE B - ID - A_ID - DESC

This is where A_ID is the foreign key (if its not obvious)

Can i create a single data flow with this kind of sequential flow of events or do I need to create another data flow for insertion of TABLE B after I inserted in table A.

推荐答案

这个msdn链接为你提供答案...... http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices /线程/ 40198093-202c-4d4a-99be -a92538032377 [ ^ ]

This msdn link provides the answer for you... http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/40198093-202c-4d4a-99be-a92538032377[^]

这篇关于SSIS数据流 - 带有所需外键值的顺序插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！