Find Jobs
Hire Freelancers

FTP File Transfer Package for SQL Server 2008 R2 SSIS

$30-250 USD

已完成
已发布将近 6 年前

$30-250 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: 17194708

关于此项目

6提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在3天之内
5.0 (6条评论)
2.9
2.9
6威客以平均价$221 USD来参与此工作竞价
用户头像
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 efficient. If you want you can contact me through chat Thanks Andres
$155 USD 在5天之内
4.9 (45条评论)
5.3
5.3
用户头像
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, I can able to start this right now if you assign me this project. Thanks
$222 USD 在3天之内
5.0 (5条评论)
1.5
1.5
用户头像
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 database for backend. Using Wordpress as CMS, and using Apache Cordova for building Hybrid App (Android & IOS) Feel free to ask anything :) Thanks
$208 USD 在4天之内
0.0 (0条评论)
0.0
0.0

关于客户

UNITED STATES的国旗
yonkers, United States
5.0
4
付款方式已验证
会员自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)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。