I have a stored procedure which I want to run on multiple SQL tasks inside a SSIS package. The stored procedure contains temp tables.
Also, each SQL task will execute the stored procedure with different parameters than others.
My question: IS IT SAFE TO RUN THEM? DOES SSIS RUN SPs THROUGH DIFFERENT SESSIONS?
Can anyone explain... by the way, I am using SQL Server 2019. I have tried it for some tasks, but I am not sure, yet it is okay or not to do?