473,320 Members | 1,883 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

How to send data from a remote Client to my FTP site

AG
Every night i want to send the new records that are created from my
remote client to my FTP site, using a application which sets up an
internet connection on the client , exports the data to the flat file
and downloads the flat file to an FTP site.

Would anyone know how to do this?
Thanks in anticipation.
Ajay

Jul 23 '05 #1
1 1690

"AG" <aj*****@hotmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
Every night i want to send the new records that are created from my
remote client to my FTP site, using a application which sets up an
internet connection on the client , exports the data to the flat file
and downloads the flat file to an FTP site.

Would anyone know how to do this?
Thanks in anticipation.
Ajay


I'm not sure what you mean by "remote client", but if you're asking how to
move data from one MSSQL or MSDE installation to another, then that's
certainly possible. There are a number of different ways, but one general
solution would be to export your data to a flat file with bcp.exe, osql.exe,
or DTS; then use a script in a language like C#, Perl, Python etc to handle
the network/FTP part. To control the whole process, you could put everything
into a DTS package or use multiple steps in a scheduled job.

If this isn't helpful, I suggest you give some more details about your
environment and which part of the process you're not sure about - your
MSSQL/MSDE version, what your "remote client" actually is, the volume of
data to transfer, where the data is going from and to, what you mean by "new
records" (copy any change to the database or only new rows from certain
tables) etc.

Simon
Jul 23 '05 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Etienne Charland | last post by:
Hi, there is an application running on a remote desktop (under Citrix ICA, but the same problem applies for RDC or PC Anywhere). Now, I want to send keys to the remote application from a local app....
0
by: AG | last post by:
Every night i want to send the new records that are created from my remote client to my FTP site, using a application which sets up an internet connection on the client , exports the data to the...
2
by: Danny J. Lesandrini | last post by:
Our orders database exists inside our firewall but we have a web site hosted on an ISP server. If we wanted to give users the ability to query the status of their order in real time, we could just...
3
by: Lyle Fairfield | last post by:
In a recent thread there has been discussion about Data Access Pages. It has been suggested that they are not permitted on many or most secure sites. Perhaps, that it is so, although I know of no...
13
by: Manfred Braun | last post by:
Hi All, I am trying to understand the blocking method socket.Send(). The call blocks as expected, but does this mean, it returnes after the underlying TCP layer got a confirmation, that the send...
2
by: eSolTec, Inc. 501(c)(3) | last post by:
I'm looking for code samples to send a jpg image from a client machine to a host machine. Both have the same image picWindows picture container. I would like to be able to send the image on one...
2
by: yvan | last post by:
Hi, Here is my client/server scenario: Step1: Client connects to server and sends data sucessfully (using Socket.Send()). Step2: Server gracefully exists (calls Socket.Shutdown() and...
5
by: Ofer Zelig | last post by:
Hello, I have a simple AJAX-enabled (RC 1.0) web site. Runs perfectly on my local machine (debugged by VS IDE). The problem is that on remote ("prodction") machine, every "satellite" file - JS,...
0
by: mlfblom | last post by:
Hi, I am running visual studio 2005 on a Vista Ultimate client. I have created a remote site on a Windows 2003 R2 server. This site has about 100 aspx, many App_Code files and several references...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.