• Hi,

    The first step in the package checks that the file exists using Visual Basic:

    Dim FileInfo As FileInfo

    ' Fill fileInfo variable with file information

    FileInfo = New FileInfo(Dts.Variables("User::strWestpacFileLocation").Value.ToString())

    'Check if file exists

    Dts.Variables("User::bFileExists").Value = FileInfo.Exists

    Dts.TaskResult = ScriptResults.Success

    I would not think that this would lock the file as it seem to be accepted as the best method of checking that the file exists...