I have developed a SSIS package to extract data from Oracle 10g Source and load into SQL Server 2008 Destination.
The package extracts data from 1500+ tables. Approximate size of total data is 1.6 GB.
I have created total 29 packages in one solution. 28 child packages is for extracting data from all tables and 1 parent package to excute all these 28 child packages. In the parent package i have include 28 "Execute Package Task".
When i run the parent package from Designer windows i.e; BIDS, it takes around 1hrs 15 mins to load
all 1500+ tables. When i deploy the package on 2008 Integration Server, it takes 13+hrs.
Source is from a different machine.
Destination database and Integration Services are installed on the local machine.
The Package was designed on the local machine.
I am not able to figure out, why its taking such a long time to execute on Integration Services...
Thanks in advance...