title: Insert one table and use their PK durning inserting second table as FK - SSIS
body: <p>I have csv file with address and person data in each row.
  I want to transform this data:
  1-Insert address part od row into Address table of db
  2-Use PK of added address row durning added person part of data to Person table which have FK to address column
  3-Person table have FK to exist in database data, how to select PK of exist data durning ssis tranformation?</p>
  
  <p>I have little experience with SSIS and I want to know how to achive that transformation?</p>
  
  <p>It is possible to save address PK in some temp ?</p>