title: Adding custom attribute to SQL DB using dynamic parameter in Azure Data factory
body: <p>I have a CSV file that I need to ingest in MS SQL DB using ADF V2. Now thats a simple thing to achieve and i am able to do it. But I each file also has a Asset ID  associated with it which is dynamically generated you can think of it as a GUID. </p>
  
  <p>Hence essentially, it is there so that in future I have a way to associate which record belong to which CSV as there can be multiple CSVs ingested.</p>
  
  <p>I am able to retrieve the asset ID in form of dynamic parameter till Pipeline but I am not able to add it to the database. Essentially there will be one additional column called assetID against each record in DB. But how to populate it with the dynamic parameter, I am not able to find a way. Can any body help? or if there is any other way to associate a Unique ID to those records of file in DB. </p>