SSIS Package Execution

Posted on 2009-12-17
Medium Priority
Last Modified: 2013-11-10
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...


Question by:vimalsk3
LVL 14

Expert Comment

ID: 26078979
Are you using the "fast load" option in your OLE DB destination?

In your OLE DB Destination, you want to be sure to use "Table or view - fast load" in the Data access mode box. It's on the main screen when you double click on the OLE DB destination.



Accepted Solution

vimalsk3 earned 0 total points
ID: 26079011
yes, i am using "fast load" option

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question