batch file transmissions -urgent pls.

[Coder94]

i need the help in how to setup batch file transmissions

i have a ftp drive

where i will put all my xml files (generated through ms-sql server 2000) to ftp site through ftp logon

1) how do i do if i want to logon to ftp site through sql server
2) how do i generate xml file and send it to the ftp site?

just to give you an overview of my batch file transmissions.

i have a centerlized ftp site where all the xml files will be accepted


i have other system its based on ms-sql server 2000 will dump all the xml file into ftp site

my question how can i generate the xml files and drop into ftp site

IMPORTANT: it has to be done all automated process with batch

what is the best to use dts if yes then what will be the macanism inloved in it......

1) i have ftp site
2) i have other customers where they will logon to the ftp site and put all the xml file
3) in the ftp site i will do the processing in terms of accept the file or reject ( this i know how to do)
4) from the customer point of view, when the customer generate the xml through ms-sql server 2000 but how should it be through dts package or any other means and should put on the nightly job? please eleborate
5)if the ftp reject the xml file how should i process the xml file on customer side, like how the ms-sql server knows that there is rejected file ?
6) if the xml is accepted then how do i update my db in ms-sql server on the customer side?

ftp (is centralized location which i do not know more detail but what i know is that, it accept the xml if it is rightly formated and rejected if not)
customer site is the one who is sending xml file to ftp site

 

[Coder94]

in other simple words:


1) Server: there is a ftp server called (BIG FTP)
2) Client: I hook to the BIG FTP site using userid, password
3) I drop all the xml file gereated thrown SQL Server
4) after i generated xml file, i dump all those files into BIG FTP site
5) once i drop all xml file into BIG FTP site then BIG FTP site validate my xml file and if everything is okay it will accept it and if not it will reject it ( i do not need to worry about this part, somebody else is doing)
5) once the server which is BIG FTP reject my file it will drop my xml file into Client FTP site and i have to pickup the xml file and open it and read it and write it to a sql server. (write in sense what reason the file being rejected)

i hope im clear

thank you for your help.

 

[Coder94]

i do not want code, i just need how this things will work, i just need the over all pic

again, i do not need code and i have 2 hours left to deadline, just need over all picture like what technology i have to use and how i have to implement this project thats all i need