Link to home
Start Free TrialLog in
Avatar of Rawan Jambi
Rawan Jambi

asked on

Adding a column to group of data

I am working on SSIS to extract data from multiple source and save them in DB.. However all the data are stored together in the DB tables with no ID about where each one of them come from.. I wonder if there is any solution that allow me to add like a special identity for each group of data from different sources??

thank you
ASKER CERTIFIED SOLUTION
Avatar of Vikas Garg
Vikas Garg
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Most tables I know where you need auditing will have four extra columns:  created_dt, created_by, last_updated_dt, and last_updated_by, and are all populated by whatever process inserts or updates rows in them.

If we're talking SSIS, then the created_by / last_updated_by can be the user id that was used to execute the job.  Or a hard-coded value.