Hi,

Actually i am having one requirement i.e

i am running some scripts that are scheduled by sql server agent and generating some files and loading that files into some path of folder c:/../../output.

from there i am copying and separating by identifying the files with some location_id like file contain words AZC(andhra),IZC(Tamilnadu)... again that are zipping and doing ftp daily basis ...so

Now i want to copy those files from output folder results of scheduled scripts and separation by identifying location id AZC,IZC and http://ftp....

these all things i have implemented by using ssis taking file from output folder and ftp. but unable to automation of ftp. its working when the package running manually so please anyone let me know how to schedule package or give me new procedure ...for achieve this.