On Oct 11, 4:48 pm, lwidjaya <lwidj...@discussions.microsoft.com>
[quoted text, click to view] wrote:
> Hi, I'm using DTS 2000
> Thanks.
>
>
>
> "jhofm...@googlemail.com" wrote:
> > On Oct 10, 10:59 pm, lwidjaya <lwidj...@discussions.microsoft.com>
> > wrote:
> > > 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.
>
> > Hi lwidjaya,
>
> > Are you using DTS 2000 or SSIS?
>
> > J- Hide quoted text -
>
> - Show quoted text -
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