File Name when using GetFilesToDirectory

#Create WinSCP session
$WinSCPSession = New-WinSCPSession -SessionOption (New-WinSCPSessionOption -HostName $sftphost -Protocol Sftp -PortNumber $port -Credential $Cred -SshHostKeyFingerprint $sftpfingerprint) 
 
#Transfer files to local directory
$WinSCPSession.GetFilesToDirectory($sftpDownloadDir,$localDir,'',$deleteRemote)
#return $filename
$WinSCPSession.close()
$WinSCPSession.Dispose()

$WinSCPSession = New-WinSCPSession -SessionOption (New-WinSCPSessionOption -HostName $sftphost -Protocol Sftp -PortNumber $port -Credential $Cred -SshHostKeyFingerprint $sftpfingerprint)
 
$transferResult = $WinSCPSession.GetFilesToDirectory($sftpDownloadDir, $localDir, '', $deleteRemote)
 
foreach ($fileTransfer in $transferResult.Transfers)
{
    $isSuccess = $fileTransfer.IsSuccess
    $fileName = $fileTransfer.FileName
    # put here inserts to DB like Invoke-Sqlcmd -ServerInstance $sqlServer -Database $database -Query "INSERT INTO YourTable (IsSuccess, FileName) VALUES ('$isSuccess', '$fileName')"
}
 
$WinSCPSession.Close()
$WinSCPSession.Dispose()