Executing stored procedures asynchronously using tasks in SSIS
Instead of SSIS I think you might want to look into SQL Server Service Broker. This lets you send messages asynchronously. See here or here for a start. 

MSMQ or RabbitMQ may also be options you should consider.