FTP FILES FROM UNIX TO WINDOWS

[PrgrmsAll]

I need to incorporate an FTP task into my DTSPackage which will FTP a file FROM a unix box onto a Windows directory. Is this possible with the File Transfer Protocol Task in SQLServer DTS?

Thanks in advance.

 

[SQLDenis]

yes
or you can put it in a bat file and call a Execute Process Task

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[PrgrmsAll]

Assuming I want to keep it within the DTS ...

I seem to be having difficulties with the source directory path. How should I have it entered? IP? or //+IP or ??

 

[SQLDenis]

just the IP
example

255.255.255.255
and select internet site for source

It might be that the firewall is blocking you from going to the outside



Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/