FTP File Transfer Package for SQL Server 2008 R2 SSIS

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.

Ferdigheter: Microsoft SQL Server, SQL, SSIS (SQL Server Integration Services), Windows-server

Se mer: ssis ftp task send multiple files, ssis secure ftp task, ssis ftp task send files, sql server ftp file transfer, ssis ftp task sftp, sql server ftp get file, ssis ftp task receive files, ssis ftp task receive multiple files, sql server 2008 r2 price dubai uae, sql server 2008 file sending ftp, sql server 2008 ftp send file, ftp sql server 2008, sql server 2008 file ftp, job export table csv ftp sql server 2008, moving sbs 2003 sql server 2008, convert access database sql server 2008, software package sql server crystalreport project vbnet, sql server 2008 express automatic backup, sql server 2008 convert access database, set automatic backup sql server 2008

Om arbeidsgiveren:
( 4 omtaler ) yonkers, United States

Prosjekt-ID: #17194708

Tildelt til:


hi I have done these tasks earlier , if you would like to work with me , ping me for more details and your requirement

$155 USD på 3 dager
(6 omtaler)

6 frilansere byr i snitt $221 for denne jobben


Hello, I read the description of the project, I can help develop the SSIS project and integrate it with the FTP client, however, I would like to propose using a windows service to do this task, it is more secure and ef Mer

$155 USD på 5 dager
(45 Omtaler)
$333 USD på 7 dager
(9 Omtaler)

Hello, I have checked your job description and I am okay to get this done for you. I can able to transfer the files according to your requirements and you will get the professional work and quality work. Also Mer

$222 USD på 3 dager
(5 Omtaler)

Thanks for the wonderful job. Hi, Hope you are doing well. I am Experienced [login to view URL] developer.I have gone through the job description and understood it well. I am interested to help you out with this, As I Mer

$255 USD på 3 dager
(0 Omtaler)

Hi there, I am a fulltime freelance web & mobile app developer. I got lot of experience on both web & mobile app development, Good with HTML, CSS, JS for frontend website Love coding with PHP and MySQL as datab Mer

$208 USD på 4 dager
(0 Omtaler)