Post reply

Data Validation

  • September 24, 2007 at 2:43 pm

    #178773

    Hi guys I need some suggestion on how to go about doing one task...

    I have to write a script that will look for problems in data in source table... I have a table that has the column names for the source table and the data-type... I need to verify in the source table if the data is valid? What is the best way to do this. Thanks in advance for help.

  • September 24, 2007 at 3:13 pm

    #735795

    First off, you'll need to be able to define what is valid and invalid data.  Can you expand on what you are looking for and include some data examples that would be considered valid and invalid?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • September 25, 2007 at 1:57 am

    #735915

    in SQL Server 2005 there are few methods for data validation and data cleansing

    http://204.9.76.233/articles/dba/data_cleaning_ssis_p1.aspx




    My Blog: http://dineshasanka.spaces.live.com/

Viewing 3 posts - 1 through 2 (of 2 total)

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