Table to FTP-site..?

[kenjoswe]

Hi all,

I need to export data from a table or texfile to a FTP-site.
How can I do this with DTS?

I have seen a FTP-object when I designed other packages but that one seems to import data from a FTP location.

/Kent J.

 

[JohnDTampaBay]

Since my filenames change, I use ActiveX to write the FTP script file. Here's a code snippet:

'------ Set up FTP script file
	IF oFSO.FileExists("C:\FTP.ftp") THEN
		oFSO.DeleteFile ("C:\FTP.ftp")
	END IF

	SET oTextFile = oFSO.CreateTextFile("C:\FTP.ftp", True)

	oTextFile.WriteLine("login")
	oTextFile.WriteLine("password")
	oTextFile.WriteLine("lcd C:\")  '-- Change local dir
	oTextFile.WriteLine("cd /subdir")  '-- Change remote dir
	oTextFile.WriteLine("put " + Trim(DTSGlobalVariables("File1").Value))
	oTextFile.WriteLine("put " + Trim(DTSGlobalVariables("File2").Value))
	oTextFile.WriteLine( "quit")
	oTextFile.Close

Then I use Execute Process Task to call FTP with the following parameter string: -s:C:\FTP.ftp IP.IP.IP.IP

Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)