SSIS Package Execution

Posted on 2009-12-17
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

    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

    yes, i am using "fast load" option

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now