VBS or DTS

[travisbrown]

I'm writing a little VBS web app that adds content to a DB. With this content, I was going to use filesystem to create html pages. I need to deliver these pages to an FTP server. Should I use VBS to attempt this, or a DTS Package? This is my first foray into automated FTP connection.

 

[yksvaan]

I don't know much about VBS web app's. Is it running on web server or in web browser ? I think you can run DTS from VBS and for sure VBS from DTS, so the are possibilities.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[travisbrown]

Runs on an application web server. I can execute DTS from an asp page, but don't know there are any known issues with connecting to an FTP site through DTS. If I do it all in an ASP page, I'll probably have to use a component.

 

[travisbrown]

Okay, perhaps I'm misguided...Can i export files to an FTP site with DTS, or just import. All I can manage right now is importing.

 

[kokkik]

DTS and VBS could perform FTP (export or import). I would prefer DTS if the system does require to capture data from DB to send data to DB in a large amount. I would use VBS if web user need to send in data thru your web application. After all, it's about balancing your load between your DB and Web Server.

If a lot of user sending files thru web and it may be wise to store the files at specific location. Then a DTS job invoked to store into DB. (Assuming the data could wait till night processing).

 

[travisbrown]

I'm not sending data to a db by FTP; I'm creating HTML pages from the database and FTP-ing them to a remote server.

How can DTS export? All I can find is an import option.

 

[yksvaan]

No there's not a ftp send task in sql2000 dts. In dts you'd have to use command file. There's one example in

http://www.sqlteam.com/item.asp?ItemID=12408

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[kokkik]

i think i've misguided earlier, DTS itself has no FTP feature. But it can incorporate either other component such as batch file, vbscript, etc to perform the task.

 

[yksvaan]

And another example without dts, which can easily be changed to send:

http://dbforums.com/t718406.html

third last one has the solution.

Cheers


[blue]Backup system is as good as the latest recovery[/blue]

 

[EdwinGene]

Travis,

DTS does not have a task for doing an FTP Upload, only an FTP Download.

However you can still use DTS to do an FTP Upload.

What I have done is to use and AciveX Script Task to create an FTP Batch and an FTP Commands file on the local hard drive; and then use an Execute SQL Task to call the FTP Batch file using the Execute xp_cmdshell command.

When the FTP is finished you can use another ActiveX Script Task to delete the FTP Commands file, since you might not want the remote Server Name and Password hanging around on the hard drive for just anyone to read.

 

[yksvaan]

And an example of FTP batch by EdwinGene on the nearby thread:
EXECUTE PROCESS TASK - FTP Files via .CMD File

Cheers


[blue]Backup system is as good as the latest recovery[/blue]