Find Jobs
Hire Freelancers

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

$10-30 USD

종료됨
게시됨 거의 6년 전

$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: 17229995

프로젝트 정보

8 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
8 이 프로젝트에 프리랜서들의 평균 입찰은 $130 USD입니다.
사용자 아바타
Hi, I'm a database architect and programmer having more than 15 years of experience with different types of domains like telecom, banking, payroll, crm, ecommerce etc with high data volumes and I'm experienced with oracle and ms-sql and also experienced with ssis. Here you need to have Filezilla to connect server which is free no other 3rd party software will be used except Filezilla with ssis. Please contact me for more information. Cheers!
$388 USD 5일에
5.0 (1 건의 리뷰)
2.5
2.5
사용자 아바타
My Core skill is SQL server Integration services, on which i have experience of 6.6 years. As i am an advanced user of SSIS i can complete this task as per your expectation.
$25 USD 1일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (UNITED STATES)
yonkers, United States
5.0
5
결제 수단 확인
10월 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)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.