We are taking Oracle Source data using Data Flow Task in which Data Reader as Source [We have Separate DSN for this] and OLE DB as destination to store the same data into SQL Server table. There are some date condition from which we are extracting data.
EX: SELECT <COLUMN NAMES> FROM <TABLE> WHERE MODIFIED_DATE BETWEEN '2013-05-01 00:00:00.000' AND '2013-05-05 00:00:00.000' -- Actually it should returns 250 rows of record and we get so.
If we using package level its taking nearly 30 to 35 minutes for extracting the data. But if i use Microsoft Query based on the same DSN [Using MS-Office Excel 2007 ODBC] it's taken only 05 minutes to get the data.
Can i know are there any possible way how to optimize my SSIS package by using Data Reader/package level?