![]() ![]()
GO SFTP CLIENT EXAMPLE DOWNLOADNavigate to the Parameters tab, where we’ll create a handful of runtime values that will make the DownloadSFTP package more reusable.Īs shown above, all of the values that might change over time – the server name, user ID and password, download directory, etc. In a new SSIS project, create a new package (I’ve named mine DownloadSFTP.dtsx). With the testing environment set up, it’s time to build a solution. Be sure to also include a few files that will not be downloaded as part of the SFTP operation for more comprehensive testing. The UI is quite simple and self-explanatory, only requiring a user name, password, port number (which defaults to 22), and the root directory.įor testing, add a few files to the root directory specified above. Next, start up the mini-SFTP server (msftpsrvr.exe). As noted, WinSCP comes with two executables – WinSCP.exe and – but this solution requires only the latter of these for command-line operations. To keep things simple, I recommend creating a utility directory to store these executables. Setting Up the Environmentįor the initial setup, download WinSCP and the Core FTP mini-SFTP server executables listed above. GO SFTP CLIENT EXAMPLE PORTABLEAlthough this is not a part of the deployed solution itself, this provides a very simple and easy-to-configure SFTP server for testing purposes.Īlso, in this example I’m using SSIS 2014 to demonstrate the solution, but this design pattern for accessing SFTP with SSIS is portable across all versions of Integration Services. In particular, this article was very helpful for some of the syntax questions I had when developing this solution.Ĭore FTP mini-SFTP server. For more information about WinSCP, check out the documentation pages, which are quite comprehensive and can give you a better understanding of how the command-line WinSCP tool works and its myriad configuration options. GO SFTP CLIENT EXAMPLE FREEThere are, of course, other free command-line SFTP tools available, but I’ve found none better than WinSCP in terms of reliability, ease of use, and documentation. The portable executables (near the top of the downloads page) are the easiest to use, as you simply drop the two executables into a folder and start using them without going through an installation process. It has both a UI and a command-line component, though I use the latter exclusively for this solution. This is a mature, well-documented, and free (GPL) SFTP client. To develop and test this solution, I use just a couple of tools: Therefore, my go-to solution for consuming SFTP with SSIS is the last one on the list above, which is the solution I describe herein. In my work as a consultant, I’ve found that the easiest solution – when considering not just the technical components but the administrative work – is to use a command-line approach leveraging a mature and well-documented SFTP client. For coding solutions using external DLLs, often the same issues exist because the external DLLs have to be registered on each server, which is an easy enough process but surprisingly difficult to get approved in many cases. GO SFTP CLIENT EXAMPLE MANUALFor example, using a third-party SSIS task provides a more streamlined approach (often requiring no manual coding at all), but often – especially in larger organizations – installing a third-party component requires so much extra testing and administrative approval that it makes it more trouble than its worth. I’ve used each of these solutions in the past, and each one has its own merits and risks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |