dbTalk Databases Forums  

contunue executing DTS package even after erros

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


Discuss contunue executing DTS package even after erros in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
ranm
 
Posts: n/a

Default contunue executing DTS package even after erros - 06-06-2004 , 03:31 PM






I created a DTS package that loads 10 files into a staging
area and then load the staging area to the fact tables.

my problem is that I want the package to continue running
even if some of the source files can not be executed
(since there is a problem with the path)

my question is ,
how can I set the package to execute all steps (even after
errors) ?
I read that there is an option settings the DTSErrorMode
to DTSErrorMode_Continue . will it help me ?

do you have another solution ?

10x in advance
ran



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.