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 |
ec_wouter
Starting Member
6 Posts |
Posted - 2006-04-04 : 11:41:06
|
Hello,I've a small question.What does it mean when you've a full green Transformation Data Task-arrow instead of a normal black one? It's not the green/white stripped one.Here's a black one, mine is in green somehow?http://www.microsoft.com/mspress/books/sampchap/4945/0735612714-11.gifWhen I execute the DTS it works though?Best regards |
|
ec_wouter
Starting Member
6 Posts |
Posted - 2006-04-04 : 11:45:00
|
sorry wrong forum, my mistake, you can delete this! |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-04-04 : 11:46:29
|
Right click the arrow->properties->precedance------------------------I think, therefore I am - Rene Descartes |
|
|
ec_wouter
Starting Member
6 Posts |
Posted - 2006-04-04 : 11:51:21
|
Thanks, well yeah that's the problem.When I remove the Precedence it stays black. When I select another Precedence (not all though) it stays black. With some it goes green.Dunno what the difference means?Best regards |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2006-04-04 : 12:15:56
|
There are only 3 precedence, COMPLETION, SUCCESS and FAILURE.Precedence - colour-------------------SUCCESS - GREENFAILURE - REDCOMPLETION - BLUE I think you are HIGH LIGHTING the arrow after changing the precedance. Click in the blank area in DTS design....don't SELECT the arrow...------------------------I think, therefore I am - Rene Descartes |
|
|
ec_wouter
Starting Member
6 Posts |
Posted - 2006-04-04 : 15:07:21
|
Thanks for helping, I wish it was that simple though.I put a small example online:You see I've selected the workflow at the bottom (green/white). Maybe the top workflow (full green) is correct but I always had those black ones (left) before.I expected the top one to be like the left one (black)?Best regards! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-04-04 : 15:17:29
|
I've only seen a transformation (which is what yours is and not a precedence arrow) turn green when I've reused the connection. If you could show us an image of the entire package, we can better help.Tara Kizeraka tduggan |
|
|
ec_wouter
Starting Member
6 Posts |
Posted - 2006-04-05 : 04:31:41
|
Oh, is it just that, it turns green when you reuse the connection. Well that solves the question, I thought there was a problem somehow with the transformation itself.Thanks much. |
|
|
|
|
|
|
|