dbTalk Databases Forums  

DTS conundrum

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


Discuss DTS conundrum in the microsoft.public.sqlserver.dts forum.



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

Default DTS conundrum - 09-03-2003 , 09:13 AM






I have created a DTS package which also produces an error
log file if and when errors occur (pretty standard). What
I would like to do is add a step which deletes the
previous error logs prior to the rest of the package
running. Is it possible to do this using ActiveX ?

Any help gratefully received

Reply With Quote
  #2  
Old   
Darren Green
 
Posts: n/a

Default Re: DTS conundrum - 09-03-2003 , 12:53 PM






In article <001501c37225$97cd33b0$a101280a (AT) phx (DOT) gbl>, Paul Falla
<pfalla (AT) health (DOT) gov.gg> writes
Quote:
I have created a DTS package which also produces an error
log file if and when errors occur (pretty standard). What
I would like to do is add a step which deletes the
previous error logs prior to the rest of the package
running. Is it possible to do this using ActiveX ?

Any help gratefully received
There is a delete file example in here -

Working with files and the FileSystemObject
(http://www.sqldts.com/default.aspx?292)


A similar process but for the built in DTS log file -

How can I overwrite the package log for each execution
(http://www.sqldts.com/default.aspx?240)
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com




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.