BIDS/SSIS packages for SFTP file download
$25-50 USD / hour
We need an SSIS package that will connect to an SFTP directly, download and delete the files from the host directly, place the files into a local directory. We require the ability to pass the following variables:
1. SFTP name
2. SFTP User Name
3. SFTP Password
4. SFTP Directly (Change directory)
5. File extension name
6. Local Directory
Currently we are setup to access an SFTP directory from a flat script file but we are not able to pass variables for the file name extension. We would like to update our packages so control all elements in variables. The ability to add or remove an SSH key is also helpful.
OS: Microsoft Server 2003 R2
SQL 2005 BIDS/SSIS
WinSCP: Latest version
Project ID: #6086619
About the project
18 freelancers are bidding on average $35/hour for this job
Hello I'd like to help you on this. I have a vast experience with .net/SSIS/CLR development. I imagine the best way to accomplish this would be for a bespoke SFTP application to be developed either as a standalone a More
Hi, I have gone through your descriptions,I am 5+ years experienced VB.NET,ASP.NET,SQL,SQL Server developer at CMMI-5 level company.I can do your job easily before your deadline . I can give you the proper steps which More
Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server databases BI, i have more than 8 years working around Microsoft Sql server anf BI development. I More
Hi Recently I worked in a similar SSIS package, where I have to get the employee data from SAP and load it in a flat file and SFTP the flat file to a location. I can complete the package in 3 hours - $ 75 . All More
I do this everyday. I will use the same technology. OS: Microsoft Server 2003 R2 SQL 2005 BIDS/SSIS WinSCP: Latest version Will add 7th parameter as SSH Key. 1. SFTP name 2. SFTP User Name 3. SFTP Password More
• Skilled database developer backed by solid credentials, strong technical skills and a five-year history of exemplary-rated performance. • Experienced in schema design, database back-up and maintenance. Skilled in di More
I am a highly experienced SSIS developer and I can do this package at a very short time period. The package parameters will be configurable in the config file. Incase any change in in SFTP server name, id or password More