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
thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.