MSSQLTips

I am new to SSIS.

I need some help how to set up an automate schedule to download a file from FTP remote server and a FTP local server to my local folder using a SSIS package.

I have a SSIS package which enters the data from the file into the database, this package is working fine.

 However, I do not know how to connect these two packages to run as one package.  I also need to set up a schedule to run regularly.

I'm much appreciated if someone can show me the steps how should I proceed next.

You would need to setup a SQL Agent job to have this scheduled to run every day for you.

Take a look at these tips:

This will do the FTP using SSIS:

http://www.mssqltips.com/tip.asp?tip=1641

This tip shows you how to setup an SSIS package as a job

http://www.mssqltips.com/tip.asp?tip=1775