BIDS/SSIS packages for SFTP file download

Cancelled Posted Jun 18, 2014 Paid on delivery
Cancelled

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

Database Programming Software Architecture SQL

Project ID: #6086619

About the project

18 proposals Remote project Active Jun 25, 2014

18 freelancers are bidding on average $35/hour for this job

PSSPL2000

i am ready to work with you on cost $18/hr. Hi Greetings !! Thank you very much for giving me opportunity to bid on your project. We are excited to take effective steps further, to make this assignment as firs More

$39 USD / hour
(45 Reviews)
7.6
CodeAmbassador

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

$52 USD / hour
(91 Reviews)
7.5
superior5

I am expert in desired skills for this project and have done similar tasks already. Please get back to me, so I can show you some of the work I have done. I will not be asking for any upfront only pay me when you are s More

$38 USD / hour
(20 Reviews)
6.7
acronymsolutions

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

$26 USD / hour
(12 Reviews)
4.3
abdellatif81

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

$31 USD / hour
(8 Reviews)
3.8
swetaxi

Hi , I am ready to work for you.I have 4 years of experience in C, C++ .net. etc.. please see some of my works also check my reviews you will get better idea about my skill.I deliver quality work within time frame. More

$41 USD / hour
(0 Reviews)
0.0
ksompalli

A proposal has not yet been provided

$41 USD / hour
(0 Reviews)
0.0
pandeeshwaran

A proposal has not yet been provided

$25 USD / hour
(0 Reviews)
0.0
AbbasK

A proposal has not yet been provided

$25 USD / hour
(0 Reviews)
0.0
dasDeveloper

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

$26 USD / hour
(0 Reviews)
0.0
assuranceES

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

$50 USD / hour
(0 Reviews)
0.0
adoniasnig

• 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

$41 USD / hour
(0 Reviews)
0.0
isolos

A proposal has not yet been provided

$41 USD / hour
(0 Reviews)
0.0
jajatibadu

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

$25 USD / hour
(0 Reviews)
0.0