I have a stored procedure which is calling **20-30 stored procedures**. I need these stored procedures to **run asynchronously**. From what I have read, it seems like executing those stored procedures using SQL tasks in SSIS is the appropriate way to do it.

I have installed required software but I am completely new to it.Can I please get some directions on how to do it? i.e run stored procedures asynchronously using SQL tasks in **SSIS**,please? Since I am completely new to it,please try to elaborate as much as possible as I have no prior knowledge of this. It will be a great help.

Thanks