dbTalk Databases Forums  

DTS ActiveScript Triggering Anti-Virus

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


Discuss DTS ActiveScript Triggering Anti-Virus in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
news.microsoft.com
 
Posts: n/a

Default DTS ActiveScript Triggering Anti-Virus - 03-16-2006 , 08:21 AM






I have a multi-step DTS process which logs in to an FTP site, opens a CSV
file, imports data, then renames and moves (archives) the file one folder
down. When I remove this active script block, everything works fine- when
I leave it in, my AV thinks there is a "backdoor.Trojan" on the machine (it
is only the FileSystemObject).

Does anyone know a way to stop triggering the AV? Below are the 3 main
actions my ActiveScript block is doing (Rename+Archive the import file /
Rename+Archive DTS log (if too big) / Create new DTS log file).




Function Main()
Dim oFSO
Dim sSourceFile
Dim sDestinationFile
Dim sDestinationFileArchive

...............
...............
...............

'1. Move the new import file to the "Processed" dir
oFSO.MoveFile sSourceFile, sDestinationFile

'2. Check the DTS log file for size constraints (>100K, rename and create
new one)

...............
...............
...............
oFSO.MoveFile sLogFile, sLogFileArchive

'3. Create new file to store future DTS logs
...............
...............
...............

oFSO.CreateTextFile sLogFile
End If

' Clean Up filesystemobject
Set oFSO = Nothing

'Return "Success" code
Main = DTSTaskExecResult_Success
End Function



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.