how to use linked servers through OLE DB connection

• NIRANJANA1977

  SSC Eights!

  Points: 854

  More actions

  November 3, 2009 at 2:01 am

  #156368

  Hi All

  I trying to access database for one or more linked servers but I am not able to connect to Database ported on respective linked servers

  Any Idea ?

• Erik Kutzler

  SSCarpal Tunnel

  Points: 4287

  More actions

  November 3, 2009 at 7:21 am

  #1074255

  You don't need to use linked servers in SSIS. Set up a proper connection manager for the actual server.

• NIRANJANA1977

  SSC Eights!

  Points: 854

  More actions

  November 3, 2009 at 9:03 pm

  #1074653

  thanks