Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 FTP without password

Author  Topic 

Rekha
Starting Member

14 Posts

Posted - 2007-04-19 : 08:35:23
Hi,
I am new to SSIS.I need to run FTP process which is done manually currently.
We have different vendors uploading files @client FTP.
we have to copy the files from FTP to prod server & send mail to DBA.

The FTP has passwords encrypted & each vendor has its own password.

How do I go about doing it.
Please also suggest good article for FTP.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-04-20 : 16:35:37
Who does ftp manually now? Nothing can do for ftp if vendor doesn't want to give you password.
Go to Top of Page

nr
SQLTeam MVY

12543 Posts

Posted - 2007-04-22 : 10:30:54
Have a look at
http://www.simple-talk.com/sql/sql-server-2005/quick-tip-performing-an-ftp-rename-in-a-ssis-script-task/

and
http://www.nigelrivett.net/#FTP

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -