Post reply

How to Tell If At Least 1 File Exists in A Collection of Subfolders

  • April 2, 2014 at 8:31 pm

    #284117

    This seems very simple but I'm drawing a blank...

    I want start up an SSIS 2005 package and first check a collection of subfolders within a main folder to see if any clients have uploaded any files into any of these subfolders. I don't initially care about any file names. I just want to know if within several subfolders within a main folder if there is at least 1 file present. If there's at least 1 file present, then I want to move forward with the ETL process specified in my package.

    I have this so far and there are tons of files within the subfolders contained within my main folder here but the fi.Length is constantly returning 0.

    Public Sub Main()

    Dim sSourceFolder As String

    sSourceFolder = Dts.Variables("SourceFolder").Value.ToString

    Dim di As DirectoryInfo = New DirectoryInfo(sSourceFolder)

    Dim fi As FileInfo() = di.GetFiles("*.*")

    If fi.Length > 0 Then

    Dts.Variables("User::isFileExists").Value = True

    Else

    Dts.Variables("User::isFileExists").Value = False

    End If

    Dts.TaskResult = Dts.Results.Success

    End Sub

    Any suggestions where I'm going wrong here?

  • April 2, 2014 at 10:07 pm

    #1702715

    Such code is a little out of my league but I don't see where you're drilling down past the main folder at all.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • April 3, 2014 at 12:15 am

    #1702734

    Jeff is correct.

    If there are no files in the main folders (except subfolders), you will get the 0 as a result.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply