Post reply

SSIS Component Data Cleansing

  • March 2, 2012 at 9:35 am

    #145037

    Hi Guys

    This is my first ever post

    We are running SQL Server 2008 standard edition. I need an SSIS component that will handle data cleansing and data quality tasks similar to Fuzzy Matching/Grouping.

    Does anyone know of any components for integrations Services that can do the job, whether open source or licensed. We cannot upgrade to SQL Server Enterprise edition due to high license cost.

    thanks

    😎

  • March 5, 2012 at 12:56 am

    #1454663

    Here you go:

    http://www.red-gate.com/products/sql-development/data-cleanser/

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 5, 2012 at 12:59 am

    #1454664

    You can also use Regulare Expressions in the script component:

    Data Cleansing with Regular Expressions in SSIS[/url]

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 5, 2012 at 5:48 am

    #1454747

    Thanks for your help

  • March 7, 2012 at 4:12 am

    #1455863

    Check out the Data Profiler Task in SSIS for Data issues

  • March 7, 2012 at 4:37 am

    #1455876

    YADAVAKARAN (3/7/2012)

    Check out the Data Profiler Task in SSIS for Data issues

    That won't clean anything, unfortunately.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 4, 2012 at 11:09 pm

    #1545889

    Data cleansing is the process of uncovering and correcting inconsistent records from a table, a set, or database. This is used mainly in databases to identify imperfect, incorrect, erroneous and irrelevant parts of the data and then modifying, replacing or deleting the incorrect data.

    Informatics Outsourcing Provides the service Worldwide.

  • October 4, 2012 at 11:22 pm

    #1545891

    I have used a script task to run a regular expression against incoming data to remove specifed characters.

    Would that help?

    Ian Cockcroft
    MCITP BI Specialist

  • October 19, 2012 at 12:09 am

    #1550726

    Data cleansing is the process of uncovering and correcting inconsistent records from a table, a set, or database. This is used mainly in databases to identify imperfect, incorrect, erroneous and irrelevant parts of the data and then modifying, replacing or deleting the incorrect data.

    Informatics Outsourcing Provides the service Worldwide.

  • October 19, 2012 at 12:24 am

    #1550727

    kalpanaganeshm (10/19/2012)

    Data cleansing is the process of uncovering and correcting inconsistent records from a table, a set, or database. This is used mainly in databases to identify imperfect, incorrect, erroneous and irrelevant parts of the data and then modifying, replacing or deleting the incorrect data.

    Informatics Outsourcing Provides the service Worldwide.

    I think your record is broken. You're repeating yourself.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • April 9, 2016 at 4:42 am

    #1870964

    At this stage, your question is the most important thing to us try to dataladder software.

    http://dataladder.com/

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply