Click here to Skip to main content
14,877,526 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted
Updated 3-Jun-13 20:13pm
v2

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900