I am trying to do the next:
1. A folder contains some excel sheets that are being generated by a DTS packages.
2. I want this excel sheets to be inserted to a FTP link (user_name
and password) automatically without any human interface, and to check
if there are any excel sheets in the folder and keep pulling the excel
sheets from the folder as long as there are
sheets. All of this needed to be done automatically.
3. Then I wanted the FTP to dump these excel sheets to another
location (another company) in a certain folder in a c:\\ drive.
4. Finally, delete the excel sheets from the folder and the FTP link after
transfer the sheets (files) to the other location.

Steps:
A. Folder_name_1 (company 1)--->> FTP (after signing in).
B. FTP --->>Folder_name_2(company_2 ).
C. Delete the excel sheets from foler_name_1.
D. Delete them also from FTP.

Hint: the FTP link is already exists.

Regards,
Mohammed.

There are two different aspects to your question:
1) Scripting an FTP session.
2) Scheduling events under Windows (from your question it sounds like
you're using Windows).

Here's a discussion of FTP scripting:
http://www.columbia.edu/kermit/ftpscripts.html for Kermit
(communication software which contains an FTP client). Here is a
discussion of scripts for the Windows ftp client:
http://support.microsoft.com/?kbid=96269.

To schedule events under Windows you can use the "at" command:
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/ntcmds.mspx
or "schtasks" (available on XP):
http://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/schtasks.mspx
or the GUI tool: Control Panel>Scheduled Tasks.