Did your "above you" insisted that you should use trigger to execute XP_CMDSHELL? Or they just told you that SSIS should start as soon as records inserted?

I would not definitely, under any circumstances, call xp_cmdsheel from a trigger - just NEVER.

You may try to create scheduled task and use msdb.dbo.sp_start_job to start it from the trigger, that may be a bit better...

Also you can use Service Broker.