title: SCOPE_IDENTITY() for bulk insert in SSIS
body: <p>In SSIS, I am able to make an insert of rows and retrieve their SCOPE_IDENTITY using OLE DB Command Task which calls stored procedure, but this is not bulk insert, it's slow load. Is it possible to get id of inserted rows using bulk insert in SSIS?</p>
  
  <p>Example:
  When inserting Customer, first I have to insert record in Person table and then use this FK in Customer table. </p>
  
  <p><strong>UPDATE:</strong></p>
  
  <p>Here's a structure of Person and Customer tables that need to be populated from external source.</p>
  
  <p><img src="https://i.stack.imgur.com/ZFUPA.png" alt="enter image description here"></p>
  
  <p>One option is to have OriginalId in Person table so that I can use it in lookup when populating Customer table. But that doesn't answer my question about SCOPE_IDENTITY and fast load</p>