Hello,
I was thinking about SSIS and was thinking about how it uses system resources but was not able to find lot of information.
Can someone tell me how SSIS uses memory and does it has a workspace when it is sorting (or transforming) data, like SQL Server uses TempDb does SSIS some space which it uses exclusively.
Thank You,
Jay