Suppose there are three servers A, B, and C. If I am excuting a package on Server B which pulls data from server A and loads into Server B, is the data first brought to Server B since that's where the package is executing and then passed on to Server B? In a second scenario let's assume there is another server D where an sql job executes a package which is stored on Server B, the package is still pulling data from A and loading into B. Will the data be pulled onto server D first in this case ,eventhough the package is stored on server B, and then finally passed onto the target server B. --- As per my current understanding in both cases data will be pulled to server B. Whereever DTEXEC runs that server will get the data for tranformation. Is that correct?Please vote for answer if it helps you.

If the package is executed on Server B, the data will be load into the memory of Server B and than write into the database. The package is executed on that server which started the package, no matter where ist is stored.