Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-10-04 : 08:04:29
|
| Rajendran Menon writes "Hi,We have developed and application in Vb.net which interacts with the Microsoft Great Plains application. One of the functionality of this application is to export data to various Excel spread sheets and then upload these Excel files to a pre-designated FTP site using FTP. (The data to be exported is obtained based on a query)Once we get the data, we are using SQL DTS package to export the data to Excel. We are fine upto this point. We now need to copy these files (this could run into say 30/40 files at a time) to a remote server via FTP. We are using ftp.exe for this using the cmd-shell command in SQL and we can copy the files. But suppose the link fails or the FTP server is down etc, our application does not know if this has happened and happily comes up with a message saying that file tranfer is successful.As this is running as a scheduled task, there is no user intervention to fix any issues. The ftp.exe application just quits if a time out has occured or if the link is not available. This is not going back to the calling application. We need a method to know if the files have been copied to the FTP site successfully or not. Any ideas on this ?Thanks" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Using FTP from DTS 