Finding files in a directory that begin with string

[datamonk]

I am working on a package in SSIS that needs to check a directory to see if any files that begin with a three character string (PDE) exist, and set the value of a variable accordingly to determine which path the package should follow next.

Here is the code I am using. I found it on a similar thread in this forum. The code runs without error but does not update the variable to 1 when a file exists. Any suggestions?

        Dim AllFiles() As String = System.IO.Directory.GetFiles("\\fcfpsvr1\share\medicare\bipimport\incomingfiles\", "*.txt")
 
        Dim I As Integer
 
        For I = 0 To AllFiles.Length - 1
            If AllFiles(I).StartsWith("PDE") Then
                System.Diagnostics.Debug.WriteLine(AllFiles(I))
                Dts.Variables("SourceFileExists").Value = 1
            End If
        Next

[datamonk]

Ah, resolved the issue. The file pathway was included as part of the filename, changing the .StartsWith() to .Contains() solved the problem.

...
If AllFiles(I).StartsWith("PDE") Then

[Killer42]

Ah, resolved the issue. The file pathway was included as part of the filename, changing the .StartsWith() to .Contains() solved the problem.

I suspect you could also shortcut the process like so...

Dim AllFiles() As String = System.IO.Directory.GetFiles("\\fcfpsvr1\share\medicare\bipimport\incomingfiles\  ", "PDE*.txt")