×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SSIS package moving very slow...

SSIS package moving very slow...

SSIS package moving very slow...

(OP)
Hello,

I have an SSIS package that basically truncates all tables in a destination database, (over 250 tables) and reloads the same tables from a different, (yet identical) database.
The database size is approximately 8GB. This process is taking over an hour to run. Does anyone know if there is a property or something of that nature that could speed up my SSIS package?

Thanks,

David

RE: SSIS package moving very slow...

I'm pretty new to SSIS myself, but I am trying something similar to what you do, albeit with somewhat fewer tables.

Can you see where the bottleneck is?  Is it in the truncation or (I suspect) the reload?

What source and destination drivers are you using to load the data?

RE: SSIS package moving very slow...

Are you moving data for all tables in a single Data Flow?

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
                           - Daffy Duck

RE: SSIS package moving very slow...

(OP)
Hello,

I am not using Data Flow, I am using Control Flow. Is  there a difference in performance?

David

RE: SSIS package moving very slow...

Are you loading the tables in sequence, or in parallel?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close