all groups > sql server dts > october 2007 >
You're in the

sql server dts

group:

Skipping bad data?


Skipping bad data? lwidjaya
10/10/2007 2:59:01 PM
sql server dts: I'm trying to import data from a Lotus Notes database (*.nsf). In the middle
of importing I got this error:
Error at Source for Row number 3333. Error encountered so far in this task:
1. [Lotus][ODBC Lotus Notes]Data value is not a valid date, time or timestamp.

Is there a way to skip the bad data and just import the rest?
Thanks in advance.
Re: Skipping bad data? jhofmeyr NO[at]SPAM googlemail.com
10/11/2007 12:00:00 AM
On Oct 10, 10:59 pm, lwidjaya <lwidj...@discussions.microsoft.com>
[quoted text, click to view]

Hi lwidjaya,

Are you using DTS 2000 or SSIS?

J
Re: Skipping bad data? lwidjaya
10/11/2007 8:48:01 AM
Hi, I'm using DTS 2000
Thanks.

[quoted text, click to view]
Re: Skipping bad data? jhofmeyr NO[at]SPAM googlemail.com
10/24/2007 9:21:12 AM
On Oct 11, 4:48 pm, lwidjaya <lwidj...@discussions.microsoft.com>
[quoted text, click to view]

Hi lwidjaya,

Sorry for the delayed response.

In DTS you don't have as much flexibility in error handling as you do
in SSIS - in your case I would advise that you load the data into an
untyped (i.e. all nvarchar columns) table and perform some basic data
quality tests (checking that the columns are the correct type for
starters!). This will allow you to flag any "bad" data and just load
the good rows into the final destination table.

Good Luck!
J
AddThis Social Bookmark Button