I've got two folders - Folder1 contains files that I want to process.
Folder2 contains files that I've processed in the past. I want to
compare the filenames as I go through and see if they're already in
folder2 before I process folder1. I've got it working, but it's
painfully slow (I've got about 325 files in Folder2). I'm using a
nested ForEach container (outer container is folder 1, inner container
is folder 2). Each of them has a variable mapped to the filename, then
in a script task, I compare the filename & move the file if it's
already been processed. It takes 3-5 minutes to run through the 300+
filenames on this network drive. What would be a better way to do
this???

I just had to do one of these for a migration, it runs quickly with 2000+
files, this is the approach I took

For Each File
script task that checks for existance in target and sets a Variable to 1
or 0
File Task that does the copy, constraint is success && Variable = 1

Paul
<unc27932 (AT) yahoo (DOT) com> wrote

have you tried NoClone? it uncovers duplicate files by true
byte-by-byte comparison, compares contents not just file name.
http://noclone.net

Paul - what script code did you use to do..."script task that checks
for existance in target"? I'm way more familiar with SQL than VBscript
or other scripting languages.


Paul Smith wrote:

I used the script task. Send me an EMail and I will give you the code

Paul
<unc27932 (AT) yahoo (DOT) com> wrote

I think I figured it out - using the filesystemobject

Dim fso
Dim Filename As String
Dim FullFilePath As String

'Get Filename from variable
Filename = Right(Dts.Variables("FileName").Value.ToString(),
13)
FullFilePath = Dts.Variables("ProcessedPath").Value.ToString()
& Filename

'Create FSO
fso = CreateObject("Scripting.FileSystemObject")

'Check to see if fileexists
If (fso.FileExists(FullFilePath)) Then
Dts.TaskResult = Dts.Results.Success
Else
Dts.TaskResult = Dts.Results.Failure
End If


Paul Smith wrote: