Adding a column to group of data

Posted on 2014-07-18
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 14

    Accepted Solution


    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 65

    Expert Comment

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

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    Suggested Solutions

    My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
    For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    729 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now