There are many ETL tools that will help you validate, cleanse and transform
DataJunction ([url]www.datajunction.com[/url]) is reasonably priced and ideal for
flat-file conversions into SQLServer and other databases. You can download a
free eval from their website.
Please reply only to the newsgroup
"Dan Allen" <dlendlen.com> wrote in message
> Hello everyone,
> I need to load a comma-delimited text file to a SQL Server
> 2000 table every day. I have no problem loading the data,
> provided the data is 'clean.' However, the load fails on
> little things, like a quotation mark embedded within a
> string, or a non-date value in a date field.
> I am assuming I need to process the data before loading,
> removing or fixing the bad records before loading. The
> file comes to me from another company. I can get them to
> fix problems, but before going that way, I want to have a
> systematic way to scan through all the records they send
> to determine which records are ok and which are bad, and
> Number of records being handled is 50,000 records per day,
> so this has to be a very efficient process.
> There must be a good utility for this. I cannot believe I
> would have to write something by hand in VB or something
> like that.
> Any information anyone can provide to help me figure out
> how to handle this situation best will be immensely
> Best regards,
> -Dan Allen