DQS & MDS Need Advice RRS feed

  • General discussion

  • Hi,

    I work for a Oil & Gas company.Our aim of the project is to migrate the data from different legacy systems to ERP.

    We wanted to use DQS for data cleansing & Validation.So basically we want to work with combination.

    Our input file is excel.before we load the data we wanted to cleanse and validate the data  by using DQS and load the data into MDS. How to achieve this?

    Should i have to create  SSIS packages to load the data from DQS to MDS staging tables?

    How should i load the data from MDS staging tables into appropriate migration database tables??

    We want to load the data into our data migration database.

    Thanks In Advance


    Monday, September 16, 2013 9:49 AM

All replies

  • I think this is a very valid question and needs answer from an expert. Has anyone attempted to use DQS and MDS along with SSIS to ensure data quality in migration project?
    Thursday, February 13, 2014 1:20 AM