SQL Server Performance

SSIS 2008 - Data Extraction is dead slow while retrieving from oracle databse

Discussion in 'SQL Server 2008 Integration Services' started by ashokksharma, Dec 27, 2010.

  1. ashokksharma New Member

    Hi
    When I tried to extract the data from oracle database it is dead slow. though my query is complex but it still it is taking 10 hours of time to retrieve 20 milions of record
    please advice some techniqes for faster retrivel.
    Thanks in advance.
  2. Luis Martin Moderator

    Kindly don't duplicate posts.

Share This Page