Deploy the package to SSIS.
Configure a job to execute it.
From ssms you can call:
USE msdb ;
EXEC dbo.sp_start_job N'Job_calling_ssis_package' ;
You can put that code in a SP and execute it.
From .NET you can call the SP executing the job.
SQL Server developer at Seavus