Create Agenda on SQL Server Agent for Run Script on SSIS

After you create all SSIS to transfer data from any platform to SQL server, now you have to set up schedule for run script as automatic by use SQL Server Agent .

At first you have to import your package to Integration Services as details here
http://www.mymemoboxs.com/2015/02/import-file-system-to-sql-integration.html

STEP-1
Open SQL Server, click on right "Jobs" at SQL Server Agent then hit on "New Job"

STEP-2

Dialogue will appear as image blow, you have to set the on "General" section
Name : "Run Company Profile" or any name as you wanted
Owner : select administrator permission by click on browse
Category : pick up on "Data collector"

STEP-3
To select source file click on "Steps"
Step name : set the process name as you wanted
Type : select SQL Server Integration Service Package
Run as : SQL Server Agent Service Account will automatic set
Package sourve : SSIS Package Store
Server : localhost or IP Server
Package : Browse for your package job

STEP-4
Click on "Execution Options" and click on "Use 32 runtime" then click Ok to finished create source package

STEP-5
To set the time to running script project by click on "Schedules" on the left menu

STEP-6To run process, click right on job schedule and select "Start job as Step"