title: Insert record into Multiple table from single excel sheet using SSIS package
body: <p>I have an Excel sheet (input) where it hold customer and address information in one sheet. I wanted to transfer to two different table with reference of CustomerID .</p>
  
  <p>Example:
  Excel sheet - CustomerName,First Name, Last Name, Phone,Job Type,Designation ,Address,Zipcode</p>
  
  <p>Need to transfer to below tables </p>
  
  <p>SQL =
  Table 1 Customer - CustomerId, First Name,Last Name , Phone ,Job Type,Designation 
  Table 2 Address  - AddressId ,CustomerId , Address , Zipcode </p>
  
  <p>I can able to transfer the information independently using SSIS without any relation between two tables.  but how to get the customerId from customer table insert into address table at the time of package execution.  </p>
  
  <p>Any idea would be appreciated.</p>