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.

 All Forums
 Old Forums
 CLOSED - General SQL Server
 green "transform data task"?

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.gif

When 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!
Go to Top of Page

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
Go to Top of Page

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
Go to Top of Page

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 - GREEN
FAILURE - RED
COMPLETION - 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
Go to Top of Page

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!
Go to Top of Page

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 Kizer
aka tduggan
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -