Post reply

SSIS Package Executed from Server C.

  • July 22, 2018 at 4:03 am

    #414422

    Morning Guys,

    I have a dedicated SSIS server and SSISDB hosted on Server C.

    Server C  executes an SSIS package that is stored in SSISDB on Server C but has connection to Server A and B.  It transfers data from Server A to Server B every 15 minutes.

    Does having the SSIS Package on Server C cause the data to detour through that server? I.e the data physically passed through Server C. Rather than going from A to B it goes A to C to B?

    Cheers
    Alex

  • July 22, 2018 at 7:03 am

    #1998521

    In simple terms, yes. There are 2 connections, A-C and B-C. SSIS doesn't create a connection between A and B, it connects to each and then feeds the data from one to the other via itself.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply