Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2011
    Posts
    25

    Question Unanswered: SSIS - OLEDB Source (Oracle) Taking long time to responce

    I have Oracle 11g as Source and SQL Server 2012 as Destination.

    When I run the package It Taking too much time to establish Connection with Oracle. ( near about 10 to 15 Min)

    After Connection Established Package run fine.

    Please Suggest any Solution to increase Performance

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    How long does it take to run a similar or the same query using SQL*Plus on the machine that is running the SSIS package? How long does it take to run that query using ODBC (such as Microsoft Excel or Access)?

    There can be thousands of bottlenecks connecting to an Oracle server. It would help a great deal if you could give us more background about the connectivity between the machine running SSIS and the machine running the Oracle database.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •