Do data flow through SSIS server to the destination database server?

• Aspet Golestanian Namagerdi

  SSCarpal Tunnel

  Points: 4444

  More actions

  January 14, 2015 at 6:15 pm

  #314559

  We have three servers(A,B and C) .

  We have a SSIS package on the (C) to load data from (A) into (B).

  Does the source data go through Integration Service Server first (C) and then land on target database server?

  or the Integration Service simply invokes the process for the db server to load the source data directly without going through Sevrer (C)?

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  January 15, 2015 at 1:36 am

  #1770340

  It goes through C.

  It loads data from A through the network into the memory of C, and then sends it through the network to B.

  If you use a data flow of course.

  A way to minimize network and RAM consumption is to use stored procedures instead.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP