troubleshooting Question

SSIS Package Execution

Avatar of vimalsk3
vimalsk3 asked on
Microsoft SQL ServerMicrosoft SQL Server 2005Microsoft SQL Server 2008
2 Comments1 Solution462 ViewsLast Modified:
Hi Experts,

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...

Regards,
Vimal


ASKER CERTIFIED SOLUTION
vimalsk3

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros