-
Jump or detect corrupt lines in DTS
Hi,
I import from CSV files into MSSQL tables.
My hierarchy absolutely wants to keep the CSV standard format.
Some string have quotes inside.
With Sybase it jumps these corrupted lines.
With MSSQL and DTS, it breaks all the importation.
Does anyone know how to jump (aloso is there a possibility to detect the number of corrupted lines, Sybase can do that) ?
Thanks for your answers
Best Regards
Axel
-
Jump or detect corrupt lines in DTS (reply)
what i did is, created a single column table. IMported all the values to that table first. removed/Fixed those corrupted values and imported to the destination table.
-MAK
------------
axel at 3/7/01 2:12:18 AM
Hi,
I import from CSV files into MSSQL tables.
My hierarchy absolutely wants to keep the CSV standard format.
Some string have quotes inside.
With Sybase it jumps these corrupted lines.
With MSSQL and DTS, it breaks all the importation.
Does anyone know how to jump (aloso is there a possibility to detect the number of corrupted lines, Sybase can do that) ?
Thanks for your answers
Best Regards
Axel
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|