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