How to repair sql table - Error in DTS

[Mac]

I have schedule DTS to import every day few tables. It had been working
great and had no problem. All of a sudden I started getting this error.

ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THE
TASK. 1 UNIDENTIFIED ERROR.

Thanks.

[serge]

Re: How to repair sql table - Error in DTS

You will need to debug it. It looks to me data related. Maybe some type
of data conversion is now failing?
If you open the DTS package and manually execute it, does SQL
give you a different error message?


"Mac" <mac@hotmail.co m> wrote in message
news:Bw%oe.7719 $nr3.2323@trndd c02...[color=blue]
> I have schedule DTS to import every day few tables. It had been working
> great and had no problem. All of a sudden I started getting this error.
>
> ERROR AT DESTINATION FOR ROW NUMBER 100. ERROR ENCOUNTERED SO FAR IN THE
> TASK. 1 UNIDENTIFIED ERROR.
>
> Thanks.
>
>
>[/color]

[Simon Hayes]

Re: How to repair sql table - Error in DTS

Here's one possible reason:

http://support.microsoft.com/?kbid=890841

If that doesn't apply, then perhaps you can give some more information
- what are the source and destination of the data, are there any
column-level transformations , have you looked at row 100 of the source
data to see if anything is in a different format from row 99 etc. You
might also post to microsoft.publi c.sqlserver.dts to see if someone has
a better suggestion.

Simon