Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
majolamp
Starting Member
15 Posts |
 Posted - 2008-04-01 : 05:00:38
|
| I designed an SSIS package about 200 packages in one project.the package extract from live to reporting server. some of my packages are very slow about 10 of them. strage enough the ones with more data number of rows run very fast. I'm using Source->Lookup->Conditional split->OLEDB Destination or OLDB Comand.Can someone help me to found out what could be the problem. I'm very new in SSIS. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-01 : 12:40:15
|
| Which step is taking more time? |
 |
|
|
majolamp
Starting Member
15 Posts |
Posted - 2008-04-02 : 03:33:24
|
| the control flow just hangs its stays on yello and some packages hangs on the lookup taking very long to run. For Example an extract from a Table with 70 589 records and one 1 record that need to be extracted takes long to load on the Control Flow (hangs). Where as some table with millions of records and thousands of record to be extracted take less than a 1 min.I'm failing to understand what could be the reason. |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2010-03-08 : 16:27:39
|
| Did you solve this issue? |
|
|
|
|
|
|
SSIS Lookup very slow to cache