Re: Validate a CSV file

I suggest using BCP to upload it to a work table and doing the INSERTs from
a SP into a clone of the target table (just schema). When the INSERT
completes, the data is validated and can safely be inserted into the working
table. Then all you have to worry about is the RI issues.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"J-T" <J-T@xxxxxxxxxx> wrote in message
news:uEyAI7ukFHA.3756@xxxxxxxxxxxxxxxxxxxxxxx
>I have a CSV file which contains comma seperated data that I need to
>validate against our database.I was thinking about loading that CSV file
>into a Typed-Dataset which has our database schema in it and then try to
>load the CSV file into that Typed-Dataset and automatically get all the
>errors and constarint violations.
>
> 1) Is it doable?
>
> 2) Because I need to check the foriegn keys as well,Can I loaded the data
> of those refferecing tables into my dataset as well?
>
> 3)If number 2 is doable ,how should I update my dataset if a key has been
> added to the existing refferncing tables?
>
>
> Thanks a lot for taking your time answering this post in advance.
>
> J-T
>


.

Relevant Pages

  • Re: Validate a CSV file
    ... my parser against the parser in this library speed and functionality ... >>validate against our database.I was thinking about loading that CSV file ... >>into a Typed-Dataset which has our database schema in it and then try to ... >> of those refferecing tables into my dataset as well? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Validate a CSV file
    ... Go to www.opennetcf.org they provide a FREE dataprovider for CSV, ... >validate against our database.I was thinking about loading that CSV file ... >into a Typed-Dataset which has our database schema in it and then try to ... > of those refferecing tables into my dataset as well? ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Importing schema properties
    ... If the users already exist in the directory you cannot use csvde to update them. ... In that case a custom script will need to be written that loops through the CSV file and updates the appropriate attributes. ... OP will confuse folks by saying schema unless they are actually modifying the schema of a domain. ... What's the best way to import schema information that we have stored in a CSV file? ...
    (microsoft.public.win2000.active_directory)
  • RE: Validating a (wrong) message just succeeds
    ... bad csv file that reproducess the problem so that I can look into this. ... I'm running into validation problems with Biztalk 2004. ... not more than the one in the schema of course. ... the 9th field of the first record is simple ...
    (microsoft.public.biztalk.general)
  • Re: What is the logic of storing XML in a Database?
    ... proprietary schema format for flatfiles and sell a proprietary tool ... for validating a CSV file that conforms to the flat file. ... I thought XML was supposed to be used for transport? ...
    (comp.databases.theory)