Find Jobs
Hire Freelancers

Automate transfer of files via sftp

$10-40 USD

Closed
Posted over 8 years ago

$10-40 USD

Paid on delivery
I have a few queries in sql and I want them to produce a csv file and setup a schedule to automatically transfer them over the sftp on a daily basis. I know how to transfer the files over sftp with a regular password (I use filezilla for that) but this one has a public and private key and I'm not sure about it. This should be an easy task for a person who's an expert in this. You will have to rdp to my computer. Please let me know if you need more information. Thanks.
Project ID: 9238868

About the project

12 proposals
Remote project
Active 8 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
12 freelancers are bidding on average $45 USD for this job
User Avatar
A proposal has not yet been provided
$40 USD in 1 day
5.0 (10 reviews)
4.4
4.4
User Avatar
Hi, This will be achieved by using WINSCP to transfer files over SFTP. A C# console application will be designed. Application will first fetch data from database and save it as csv. Then FTP will be connected using WINSCP and file will be uploaded. I have 9 years experience in C#, ASP.NET and SQL Server. Thanks
$45 USD in 2 days
4.2 (2 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
5.0 (2 reviews)
2.4
2.4
User Avatar
SQL SERVER DBA/MSBI Developer with 5+ years of experience. I have expertise in creating ssis packages and I can get this job done. I'll set up a daily job to create a CSV file by executing those queries and copy the file to ftp path. Please get in touch with me so that we can further discuss on this
$24 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a Microsoft Technologies Developer with having 5+ years of Experience. I am ready to take any challenge and prove my ability. You can contact me for Any Microsoft .Net Framework application, I am also very good in jQuery and other Javascript Libraries.
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 4 + years of experience in MSBI Technology(SQL Server 2008/2012) Worked with the reputed clients like Microsoft and Dick Sporting goods. Worked with the Huge datasets , Query optimization,Execution plans ,SSIS logging etc Expert in creating Sql queries ,Dynamic T-sql,functions,triggers,indexes ,Table Partitioning, triggers etc. Expert in creating SSIS package ,configuration,Deployment and Scheduling and extracting the data from different sources like SharePoint lists,excel files,csv files,Data feedstore,MySQL database,sql database etc Expert in creating different ssrs reports like drill through,drill down,parameterized,table,matrix, tablix etc SSRS reports integration with SharePoint and with web services . Moreover, Believes in Error prone ,Automated and Dynamic Solution.
$45 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Well, I'm experienced with SQL Server and Unix platforms, which by your brief description seems to be the OS that will receive your files. My approach will be a small script that queries your data, writes a .csv file as per your format requires, upload the file to the server and store it locally, with a activity log containing detailed information about the whole solution, with respective dates and times. I can do it using Java, VBScript, VBasic... the flavour thar serves you the best. Since it's my first bid on freelancer.com, I'm putting a very small value, besides my experience. Regards!
$20 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have used public/private key authentication on linux system. I can configure on filezilla/winscp. Please provide me access to your desktop
$35 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Afternoon, I can help you with the SQL to CSV and SFTP. I have written PowerShell scripts to do this in the past.
$166 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I have been working in Reporting and Database development field for more than two years. I have worked on many tasks that include automated email of csv, excel files from sql. I have also worked on 3,4 csv file transfers via ftp/sftp using c#. I am sure i can deliver the task as i've hands on experience on this type of task. I can show sample programs for reference.
$37 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm an expert Windows application developer and can deliver this software for automated uploading to SFTP for you, within 4 days or less. Good quality work done. Thanks for considering my bid. Bests, Larry
$120 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. I've already had a working scheme of your integration in big corporation that works perfect. External program used for sftp transfers (not a FileZilla) is open source.
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I'm sql dba, I can automate this process by integrating sql agent and powershell, This is not complex task.
$40 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Irving, United States
5.0
3
Payment method verified
Member since Sep 23, 2011

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.