Adding a column to group of data

Posted on 2014-07-18
Medium Priority
Last Modified: 2016-02-11
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
Question by:Rawan Jambi
LVL 15

Accepted Solution

Vikas Garg earned 1500 total points
ID: 40204059

It's simple you can either add Audit Column or an additional derived column which Extracting data from the source which will let you know from which source the data is coming and store that column in the database as identity of the data ..

Hope this would help
LVL 66

Expert Comment

by:Jim Horn
ID: 40204365
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.

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question