I am trying to understand what happens when I extract data from DB2 from a SSIS package and load it into SQL Server.
My question is: where is the data when it is between DB2 and SQL Server? On my personal computer? I mean does the data "pass through" the memory on my personal laptop and then gets sent to SQL Server?
Best Answer
It depends where the SSIS Package is running, but yes the machine or server it's running on is a passthrough between your DB2 server and your SQL server. So the data is loaded into memory of the machine where the SSIS Package is running on, and if you're using certain data transformations and variables, those consume additional memory on the SSIS server also.
This article goes a little more in depth and has good information on the memory consumption of SSIS.