dbTalk Databases Forums  

Is it possible to ignore errors?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Is it possible to ignore errors? in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Juan Ant.
 
Posts: n/a

Default Is it possible to ignore errors? - 02-06-2006 , 10:39 AM






Hi. I have a datapump task, and I need my dts to ignore any error and
continue working. I just want my DTS to insert the registries it can,
and don't fail if it finds a registry it can't insert (obviously, I'm
not asking it to insert those wrong registries..)

Is it possible?


Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Is it possible to ignore errors? - 02-06-2006 , 10:45 AM






Hello Juan Ant.,

Have a look at setting the Error Count on the Transform Data task (Last Tab)
to a really high number.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:
Hi. I have a datapump task, and I need my dts to ignore any error and
continue working. I just want my DTS to insert the registries it can,
and don't fail if it finds a registry it can't insert (obviously, I'm
not asking it to insert those wrong registries..)

Is it possible?




Reply With Quote
  #3  
Old   
Juan Ant.
 
Posts: n/a

Default Re: Is it possible to ignore errors? - 02-06-2006 , 10:47 AM



But if I need a number of rows higher than 9999 ?


Reply With Quote
  #4  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: Is it possible to ignore errors? - 02-06-2006 , 11:25 AM



Hello Juan Ant.,

use Disconnected Edit. The 9999 is a feature of the UI not the property
itself

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:
But if I need a number of rows higher than 9999 ?




Reply With Quote
  #5  
Old   
Juan Ant.
 
Posts: n/a

Default Re: Is it possible to ignore errors? - 02-06-2006 , 12:02 PM



That's perfect.

Thanks Allan!


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.