如何安排从数据库自动转移到FTP帐户？ [英] How to schedule a automatic transfer to FTP account from database?

问题描述

亲爱的，



我正在写信寻求帮助，我可以使用什么技术，这可以让我使用sql server的sql查询来调用数据，并将数据保存为.csv文件并将.csv文件导出到FTP帐户。



我也想知道，我怎样才能实现这个每日和预定的时间。我可以从我的端到FTP源添加安全措施，因此只有一个用户可以访问它。 FTP文件夹帐户由第三方客户端提供。



请告知我需要做些什么来实现这项任务。



谢谢

解决方案

步骤1：使用BCP和存储过程创建CSV文件 [ ^ ]



第2步：< a href =http://www.nigelrivett.net/FTP/s_ftp_PutFile.html>参考此存储过程并自定义您的需求 [ ^ ]



步骤3：安排作业从后台执行运行应用程序或从SQL Server代理

另一种解决方案：实施SSIS包并在服务器上部署所有需求

Dear all,

I am writing to seek help, in what technology I can use, which can allow me to call data using sql query from the sql server, and save the data as .csv file and export the .csv file to FTP account.

I would also like to know, how can I carry out this daily and scheduled time. Can I add security measure from my end to the FTP feed, so only one user can access it. The FTP folder account is provided from third party client.

Please advice on what I need to look into to implement this task.

Thank you

解决方案

Step 1: Creating CSV Files Using BCP and Stored Procedures[^]

Step 2: Refer this Stored Procedure and customize your needs[^]

Step 3: Schedule a Job to execute from your background run application or from SQL Server Agent

An other solution: Implement SSIS package and deploy on server support all your needs

这篇关于如何安排从数据库自动转移到FTP帐户？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！