dbTalk Databases Forums  

Failed DTS Package Log

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


Discuss Failed DTS Package Log in the microsoft.public.sqlserver.dts forum.



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

Default Failed DTS Package Log - 07-07-2003 , 03:41 PM






Hi,
I would like to see only error messages of packages that
fail. I have setup packages that import data from text
files that are FTP from the AS400. I have a file that all
failed error messages go to, but my problem is that
successful messages are also going there. In DTS package
properties under the logging tab, I have checked (fail
package on first error). How do I send only failed package
messages?

Thank you

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

Default Re: Failed DTS Package Log - 07-07-2003 , 04:37 PM






I do not thin you can filter what gets sent to the text file. Nice thought
though and if you want to see this feature (Maybe a toggle ON/OFF) in a
future release you may want to give these guys a mail

sqlwish (AT) microsoft (DOT) com



--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Donna" <donna.maxwell (AT) lyco (DOT) org> wrote

Quote:
Hi,
I would like to see only error messages of packages that
fail. I have setup packages that import data from text
files that are FTP from the AS400. I have a file that all
failed error messages go to, but my problem is that
successful messages are also going there. In DTS package
properties under the logging tab, I have checked (fail
package on first error). How do I send only failed package
messages?

Thank you



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.