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 |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2009-01-02 : 20:14:27
|
| I have 2 execute package task. They finished successfully. See picture. Even if it has finished successfully. The package doesn't turn green. It's yellow color. http://www.sqlservercentral.com/Forums/Attachment2009.aspx |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-03 : 07:02:27
|
| thats means the sequence container hasnty finished execution yet. its still waiting for something. are you using transaction inside sequence container? whats the transaction property thats currently set? |
 |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2009-01-06 : 21:10:32
|
| seems like the package hasnt completed. Once completed it turned green. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-07 : 10:24:59
|
| yup. it will take quite sometime,if it has to transfer large number of data and doesnt have enough buffer as transfer will take place in batches.also sometime will take for post and preeexcute phases. |
|
|
|
|
|
|
2 execute package task. Blew up