sql server dts: need to learn how to get and put table on my web site (via ftp?) -- sql server dts

need to learn how to get and put table on my web site (via ftp?)

Neil Jarman
7/28/2004 12:48:38 PM

sql server dts:

Hi,

I am new to SQL server.

I have updated my web site to SQL server (used to use Access sucessfully)

I now need to synchronise both ways -
ie some data is created on the server and need putting on the web
and some data is created on the web and needs fetching back to the server.

I have played with dts and can move data from access to sql and vice versa
(locally) but can't understand how to make the connection to my ftp.

Needless to say I have all the connection info and have verified this is
working (ie Dreamweaver connected OK)

thanks for any help.

NEIL

Re: need to learn how to get and put table on my web site (via ftp?)

Allan Mitchell
7/28/2004 1:51:04 PM

To make the connection to an FTP site to

GET = you can use the FTP tasl inside DTS or you can use FTP.exe inside a
batch file and call through the ExecuteProcess task
PUT = FTP.exe inside a batch file.

HTH

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

[quoted text, click to view]