Deploy the package to SSIS.

Configure a job to execute it.

From ssms you can call:

USE msdb ;

GO

EXEC dbo.sp_start_job N'Job_calling_ssis_package' ;

GO

You can put that code in a SP and execute it.

From .NET you can call the SP executing the job.

Regards,

Igor Micev