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 |
|
rockstar283
Yak Posting Veteran
96 Posts |
 Posted - 2011-06-06 : 12:43:43
|
| Guys..I am developing a package in which m using checkpointing..but dnt know why..checkopint update is taking aweful long time..it is actually behaving like following..n m using the same checkpoint settings in other packages..but not havin any probs there..Information: Checkpoint file "C:\ETLROOT\Scratch\\Dsc_Lprod_checkpointFile" was updated to record completion of this container.Progress: - 0 percent completeProgress: - 1 percent completeProgress: - 2 percent completeMy package has 3 containers..in first container, I extract the data from source..in 2nd container..I apply transformations to the incoming data and insert into a temp table..in 3rd container..I either append the new rows to the existing data or update the existing data depednging on the quality of incoming data..so can anybody pls throw some light on this.. |
|
|
|
|
|
Checkpointing taking lot of time