Find Jobs
Hire Freelancers

FTP File Transfer Package for SQL Server 2008 R2 SSIS -- 3

$10-30 USD

Закрито
Опублікований almost 6 years ago

$10-30 USD

Оплачується при отриманні
I need a SQL Server 2008 R2 SSIS package that performs the task of moving source files located within specific folders on a file server to matching folders on an SFTP target. The Functionality should be as follows: 1. There are 4 or 5 specifically named folders located on my local file server. For example let's say the following folders exist in my source file server: folderw, folderx, foldery, folderz 2. Each folder has a different amount of files placed into it on a daily basis by another automated process. The number of files in each folder may vary on a daily basis and the file names may be completely random. 3. The same folders also exist on a target FTP site. Target folders = folderw, folderx, foldery, folderz 4. Ths SSIS package should copy all the files from the source folders to the matching folder on the target FTP site. The number of files in the folder vary daily. The programming should dynamically loop through all the files which exist in the folder and transfer them to the target folder with in a serialized manner. They do not have to be sent in any specific order as long as they are all transmitted. 5. After the files are copied to their matching target folders, the files should also be copied into an archive folder on the file server. 6. After each successful transmission an email should be sent to certain recipient(s) which either lists the names of all the files sent in the email body or may be attached in a simple text file. Whatever is easier to implement. This project applies to a Windows Server 2008 environment running SQL Server 2008 R2. I would like to use the standard SSIS components but will consider the use of a 3rd party add-on component (at a reasonable price) if it speeds up the delivery of this project.
ID проекту: 17229997

Про проект

12 пропозицій(-ї)
Дистанційний проект
Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
12 фрілансерів(-и) готові виконати цю роботу у середньому за $80 USD
Аватарка користувача
hi, in the past I worked with sending files to sftp server, I can build a vb.net. application to run every minute, check folders for new files, send to sftp server, move to backup folder and send mail, don't need pay for extra components ( I use free sftp client to send files). don't need to use sql server functions.
$150 USD за 3 дні(-в)
5,0 (10 відгуки(-ів))
4,3
4,3
Аватарка користувача
Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. Please feel free to discuss the project with me so that I can wrap it up in a timely manner as per your requirements. Thanks, Murtaza
$200 USD за 3 дні(-в)
5,0 (2 відгуки(-ів))
3,9
3,9
Аватарка користувача
hello sir I have a 3 years of experience in SQL server management as I have read your requirement and i can do it within the given deadline thanks
$66 USD за 1 день
5,0 (2 відгуки(-ів))
1,9
1,9
Аватарка користувача
Certified MSBI -Data Warehousing expert, working in this tool from last 9 years. Have already worked on the script as source excel files to various destinations. Relevant Skills and Experience MSBI, SSIS , ETL, DW, .NET
$30 USD за 1 день
5,0 (2 відгуки(-ів))
0,4
0,4
Аватарка користувача
Hi I am interested in the FTP File Transfer Package for SQL Server 2008 R2 SSIS - 3 project that I recently published, particularly since it is System Administrator, since it is the area in which I work and I have more experience, mainly in distributions such as Windows Server 2008 R2, Windows Server 2012 R2, SQL SERVER 2008, and automatic processes with the task scheduler, I have already done projects similar to what you are requesting, such as programming a script to pass information between two Windows server servers 2008 using a SFTP in Cloud. I am constantly learning to improve my skills as System Administrator and give better and faster solutions to my clients. I am in full availability to start soon, feel free to contact me to further discuss the project. Sincerely Jose Gutierrez
$25 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
Hi, I am a microsoft certified solutions expert in Data Management and Analytics and have been working in the Microsoft BI stack for the past 6 years. I look forward to hearing from you. Thanks, Falah
$25 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
In day to day life while working in digital marketing domain,i am receiving huge different number of files to different ftp,sftp as well as s3,so i can do it with 100% dynamically.
$25 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I'm a full stack developer, working in data warehousing, database, and SSIS on a regular basis. I've completed similar requirements within SSIS many times. The endpoint for the files is per the SSIS "FTP Connection Manager", as you may already be familiar with. My instincts say that each file-folder path should be parameterized in a way that does not require redeployment should the paths change. Yes, I am new to Freelancer.com and am currently building a profile. Please let me know if you have any questions regarding. I look forward to working with you.
$55 USD за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
yonkers, United States
5,0
5
Спосіб оплати верифіковано
На сайті з жовт. 31, 2016

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.