Answered by:
BizTalk 2016 SFTP is not working for me

Question
-
Hi All,
I am trying to pick the file from SFTP location using BizTalk 2016 trial version but no luck. As per MSFT recommendation's completed below things.
1. Installed WinScp 5.15.2
Reference - Eventlog error message
SFTP adapter requires WinSCP to be installed. Please refer http://go.microsoft.com/fwlink/?LinkID=730458&clcid=0x409
2. Placed WinSCP and WinSCPnet.dll in BizTalk Installation folder
https://randypaulo.com/2018/08/13/biztalk-sftp-adapter-missing-winscpnet-library/
3. Added WinScp version in BizTalk Configuration files
https://docs.microsoft.com/en-us/biztalk/core/sftp-adapter#use-a-newer-winscp-version
Note: BizTalk 2016 CU5 installed on Win Server 2012 R2
Regards,
Thanks,Raja Microsoft Certified Contributor(MCC)2011, MSFT Partner BTS Certified in 2006, 2010 If this answers your question please mark it accordingly
Answers
-
I tried this SFTP testing in BizTalk 2016 box that was migrated from BizTalk 2013 r2.
I uninstalled BizTalk 2016 migration one and freshly install BizTalk 2016. I had tried SFTP that was working as expected.
I have not installed any CU, no entry added in BizTalk configuration file and used below .ps1. The SFTP is working fine.
#Parameters
$downloadNoGetTo = “C:\Software\WinSCP”
$bizTalkInstallFolder = “C:\Program Files (x86)\Microsoft BizTalk Server 2016”
#Download NuGet
Write-Host “Downloading Nuget”
$sourceNugetExe = “https://dist.nuget.org/win-x86-commandline/latest/nuget.exe”
$targetNugetExe = “$downloadNoGetTo\nuget.exe”
Invoke-WebRequest $sourceNugetExe -OutFile $targetNugetExe
#Download the right version of WinSCP
Write-Host “Downloading WinSCP from NuGet”
Invoke-Expression “$targetNugetExe Install WinSCP -Version 5.7.7 -OutputDirectory $downloadNoGetTo”
#Copy WinSCP items to BizTalk Folder
Write-Host “Copying WinSCP Nuget to BizTalk Folder”
Copy-Item “$downloadNoGetTo\WinSCP.5.7.7\content\WinSCP.exe” $bizTalkInstallFolder
Copy-Item “$downloadNoGetTo\WinSCP.5.7.7\lib\WinSCPnet.dll” $bizTalkInstallFolderRegards,
Raja
Thanks,Raja Microsoft Certified Contributor(MCC)2011, MSFT Partner BTS Certified in 2006, 2010 If this answers your question please mark it accordingly
- Marked as answer by Raja.Kumaravel Wednesday, July 31, 2019 1:26 PM
All replies
-
-
Hi Phanindra,
Thank you.
I had executed the setup and installed the WinScp. Restarted the machine also.
Regards,
Raja
Thanks,Raja Microsoft Certified Contributor(MCC)2011, MSFT Partner BTS Certified in 2006, 2010 If this answers your question please mark it accordingly
-
Hey Raja ,
I was also updated the winscp when I performed the CU in my machine
as per my knowledge we have to download the package and you need to replace the default winscp application and dll with new onesonce you download winscp-5.xx.x-Automation you will find application and dll
I misse the link to paste here
-
-
-
-
I tried this SFTP testing in BizTalk 2016 box that was migrated from BizTalk 2013 r2.
I uninstalled BizTalk 2016 migration one and freshly install BizTalk 2016. I had tried SFTP that was working as expected.
I have not installed any CU, no entry added in BizTalk configuration file and used below .ps1. The SFTP is working fine.
#Parameters
$downloadNoGetTo = “C:\Software\WinSCP”
$bizTalkInstallFolder = “C:\Program Files (x86)\Microsoft BizTalk Server 2016”
#Download NuGet
Write-Host “Downloading Nuget”
$sourceNugetExe = “https://dist.nuget.org/win-x86-commandline/latest/nuget.exe”
$targetNugetExe = “$downloadNoGetTo\nuget.exe”
Invoke-WebRequest $sourceNugetExe -OutFile $targetNugetExe
#Download the right version of WinSCP
Write-Host “Downloading WinSCP from NuGet”
Invoke-Expression “$targetNugetExe Install WinSCP -Version 5.7.7 -OutputDirectory $downloadNoGetTo”
#Copy WinSCP items to BizTalk Folder
Write-Host “Copying WinSCP Nuget to BizTalk Folder”
Copy-Item “$downloadNoGetTo\WinSCP.5.7.7\content\WinSCP.exe” $bizTalkInstallFolder
Copy-Item “$downloadNoGetTo\WinSCP.5.7.7\lib\WinSCPnet.dll” $bizTalkInstallFolderRegards,
Raja
Thanks,Raja Microsoft Certified Contributor(MCC)2011, MSFT Partner BTS Certified in 2006, 2010 If this answers your question please mark it accordingly
- Marked as answer by Raja.Kumaravel Wednesday, July 31, 2019 1:26 PM
-
-
Colin,
It was in-place upgrade from 2013 r2 to 2016.
I tested with below Feature Pack 3 but still no luck so tried fresh BizTalk 2016 installation.
https://www.microsoft.com/en-us/download/details.aspx?id=57077
Regards,
Thanks,Raja Microsoft Certified Contributor(MCC)2011, MSFT Partner BTS Certified in 2006, 2010 If this answers your question please mark it accordingly
-
But when you did the fresh install of BizTalk 2016, did you apply feature Pack 3 again?
If it works then, then the issue was caused by it being a in place upgrade.
P.S. There is a Microsoft BizTalk Server 2016 Feature Update 3 with CU6 that you should be using rather than the CU5 one. This will give you Improvement: Add read-only download options for SFTP adapter in BizTalk server and FIX: Duplicate files received by SFTP adapter when long time is taken for message processing in BizTalk Server
- Edited by Colin Dijkgraaf Thursday, August 1, 2019 4:38 AM
-
Colin,
No CU installed in fresh BT 2016 and SFTP is working fine. I believe the SFTP issue occured due to in-place upgrade.
Thanks,Raja Microsoft Certified Contributor(MCC)2011, MSFT Partner BTS Certified in 2006, 2010 If this answers your question please mark it accordingly
-
Colin,
As per my requirement, BizTalk is picking the file from SFTP. Hence it is working as expected without any CU.
Thanks,Raja Microsoft Certified Contributor(MCC)2011, MSFT Partner BTS Certified in 2006, 2010 If this answers your question please mark it accordingly
-
-