Home Forums Data Warehousing Integration Services When query is too long for OLE DB DFT, what are my options for bridging two servers? RE: When query is too long for OLE DB DFT, what are my options for bridging two servers?

  • Hi Jeff, Oh, I did mention synonyms to them.

    The reason (verbatim) they gave:

    "Using a linked server you may get into a double hop situation which we would not be able to resolve without assistance from the team that owns the other server."

    BTW, both servers are owned by the same organization, but within the organization, one group owns one server and another group the other.

    Is there anything I can do to accommodate the deployment team, by modifying SSIS?

    Addendum:

    I realized that since my big query contains several UNION ALLS. Am taking each query and putting into seperate OLE DB sources. In this way will be able to utilize OLE DB source and avoid linked server.

    --Quote me