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?

Expand|Select|Wrap|Line Numbers

 
        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.

Quote:

Originally Posted by datamonk

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

Killer42

Quote:

Originally Posted by datamonk

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...

Expand|Select|Wrap|Line Numbers

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

Finding files in a directory that begin with string

re: Finding files in a directory that begin with string

re: Finding files in a directory that begin with string

Similar Visual Basic 4 / 5 / 6 bytes

/bytes/development

/bytes/it

/bytes/about