You could also call the SSIS package directly too if you wanted

DECLARE @sqlCmd VARCHAR(1250) -- call to ssis package

,@returnCode INT -- returncode from package execution

,@ssisPath VARCHAR(1250)- location of ssis package

SET @ssisPath = '\\server\ssis\mySSISPackage.dtsx'

SELECT @sqlCmd = 'DTEXEC /F "' + @ssisPath + '"'

-- call ssis package and return result

EXEC @returnCode=Master..xp_cmdshell @sqlCmd

SELECT @returnCode AS '@returnCode'