Find Jobs
Hire Freelancers

Automate running SQL to tabe delimited, PGP encryption, sftp upload

$100-350 USD

Tamamlandı
İlan edilme: neredeyse 3 yıl önce

$100-350 USD

Teslimde ödenir
Automation of the following process is needed. I have 3 separate queries which I have completed in MS SQL. I need to run and get the result set to tab delimited. there will be 3 text files in tab delimited format as a result of the queries being run. Once the results sets are in tab delimited a copy needs to be put in an archive folder and a second copy needs to be encrypted to PGP using a 1024 key I have already. Upon that step being completed the PGP needs to be copied to a sftp. Once it copies over and is verified those files which were copied need to be archived in a separate folder and the folder that was used for FTP needs to be empty. If the sFTP fails the pgp encrypted files need to stay in the folder to help indicate a failure. These sql results are intended to be run after hours around 10:00 pm (22:00) and the copy is intended to happen around 11:00 pm (23:00). I would like to automate the entire process, I believe this would be best completed by Powershell, and an FTP client which supports sftp.
Proje No: 29827201

Proje hakkında

7 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 3 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
Seçilen:
Kullanıcı Avatarı
Hello, I may have 2 easy options for you. One usng powershell and other using a small .exe file which will have the auto-executed which can be set within the apps its self. The small apps would be written in C# with user interface you could manage such as which table, time for execution, sftp configuration, etc. So it offers the easy configuration instead of using powershell where you should do script modification or command line arguments. Let me know which one you prefer? Best Regards Khamid
$200 USD 1 gün içinde
5,0 (3 değerlendirme)
4,2
4,2
7 freelancers are bidding on average $221 USD for this job
Kullanıcı Avatarı
Hi, I'm .NET expert. I developed many applications using C#. I can develop these 3 processes and send a demo video before award. Looking forward to work with you. Regards
$250 USD 5 gün içinde
5,0 (12 değerlendirme)
3,9
3,9
Kullanıcı Avatarı
Hi Client , I already done many similar tasks and I can close this task quickly. I’m a Senior Software Developer & Freelance Web & Automation developer with 7+ years of experiences with Master degree holder and expertise in POWERSHELL, PYTHON, PHP, HTML 5, CSS3, JAVASCRIPT, NODE. JS, MYSQL, MONGODB, MACHINE LEARNING, DEEP LEARNING, AZURE CLOUD, AWS, DEVOPS, JENKINS, DOCKER, ANSIBLE technology with complete Full stack web developer and automation scripting developer. I’m a huge fan of the work, my goal is to get the project done on time with client satisfaction. If you have the time, I’d like to chat with you about the job requirements of yours. If you have time to talk, you can reach me anytime Thanks for your time, and I look forward to hearing from you.
$100 USD 1 gün içinde
5,0 (8 değerlendirme)
3,6
3,6
Kullanıcı Avatarı
Hello there, to automate the process within MSSQL there're many choice we can pick up such as writing a program to do it but the tool should be consider here should be the ETL tool, i recommend SSIS (SQL Server Integration Service) because it reads the data from MSSQL, then output to csv file. After that we will do some other thing such as copy folder, encryption (SSIS use the Execution Process task to call the encryption PGP outside to encrypt). Finally when they're done by that then copy to the proper destination using the FTP protocol calling from inside SSIS (Using the built-in SFTP task). Within SSIS to deploy you can monitor the steps to see where the files is now, which step is failed.... Pls share me more thing to discuss. Waiting for your response if interested. Thank you!!!
$350 USD 7 gün içinde
5,0 (2 değerlendirme)
3,1
3,1
Kullanıcı Avatarı
Hi, I am a MSSQL expert. I can do it in an hour. Let's start work right now. Please contact me. Thanks.
$200 USD 1 gün içinde
0,0 (0 değerlendirme)
0,0
0,0
Kullanıcı Avatarı
Hi there, I read you project description carefully and understood your requirement. I can automate the entire process. I've plenty of experience with SQL Server and PowerShell scripting and I've pretty confident that I can deliver you quality work in cost effective manner. I'm readily available to take your task up. lets discuss the further details in the chat. I'm new to freelancer but I have extensive experience working with C#, SQL Server, PowerShell and other Microsoft tools and technologies (Please refer my profile). your satisfaction with my work will be my reward I assure you that I Will - Deliver quality work on time and agreed budget - run extra miles to accomplish milestones - Maintain complete transparency in my work to base our long term professional relationship looking forward to work with you
$250 USD 5 gün içinde
0,0 (0 değerlendirme)
0,0
0,0

Müşteri hakkında

   UNITED STATES bayrağı
bryson city, United States
4,8
86
Ödeme yöntemi onaylandı
Kas 29, 2010 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.