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.