DTS transformation error handling

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Dmitri Todorov<dmitri.todorov@xxxxxxxxx>
Date: Fri, 27 Jul 2007 16:05:06 GMT

Hi All!
I need to copy data from DBF file into SQL table by DTS.
Some of the rows are corrupt.
I would like to copy data row by row, if exception arise ("bad row") - put that row into another table or text file and continue to the end of the DBF file.
Any suggestions appreciated.

From http://www.developmentnow.com/g/103_2004_4_0_0_0/sql-server-dts.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com
.

Prev by Date: Re: SSIS - can SSIS pkg recognize a drive letter within SMS job?
Next by Date: Import text files with batch headers
Previous by thread: Re: SQL2005 SSIS data import from flat file
Next by thread: Import text files with batch headers
Index(es):
- Date
- Thread

Relevant Pages

Re: Bulk import
... I don't have any experice with DTS ... idea how to 'replace step 5 with importing your DBF file' ... >Looping, Importing and Archiving ... >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
(microsoft.public.sqlserver.dts)
BIG SOS. I need to create a dts to export to a dbf file.
... I need to create a dts to export to a dbf file. ... Where it gets tricky is ... caokou's Profile: http://www.dbtalk.net/m718 ...
(microsoft.public.sqlserver.dts)
DBF File
... Does anyone know of a way to truncate a DBF file in DTS (SQL 2K)? ...
(microsoft.public.sqlserver.dts)