SQL Server Performance

Oracle procedure from DTS

Discussion in 'SQL Server DTS-Related Questions' started by rosh80, Apr 17, 2007.

  1. rosh80 New Member

    How do u call an Oracle procedure from a DTS?

    thanks
    Rosh
  2. satya Moderator

    Why not connect directly to the Oracle server using an Oracle connection object in the DTS package?

    Linked servers connection should help you get the better results.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page