SSIS Question about network utilization with transfer Objects between servers when package running on third SSIS server

• joverbey

  Valued Member

  Points: 71

  More actions

  August 18, 2011 at 2:46 pm

  #246457

  I have a situation where someone built an SSIS package that is transferring an object from ServerA to ServerB running an SSIS on ServerC that uses a 'Transfer SQL Server Objects' Control flow. Has anyone tested whether the data transfers directly between ServerA and ServerB or if it goes from ServerA to ServerC(where the SSIS package is installed and running)and then to ServerB?

• Elliott Whitlow

  SSC Guru

  Points: 102402

  More actions

  August 24, 2011 at 9:57 pm

  #1372931

  The answer is that the machine that is running the package sits between the other two servers.

  Also, why are you using the transfer objects task?

  What are you trying to accomplish?

  CEWII