July 25, 2006 at 3:06 pm
I'm missing the obvious, I'm sure...
But how the heck does one change which object those silly green arrows points to? DestinationName in properties appears to be read only, I don't see it anywhere in advanced editing and simple click/drag operations just move the lines of the arrow around.
July 25, 2006 at 4:00 pm
Pam
This used to be done by global variables in 2000. Now you have to use expressions in SQL 2005. First you declare your user defined variables and then use the expressions to point to the user defined variabels. Let me know if you need any other help
Marvin
Marvin Dillard
Senior Consultant
Claraview Inc
July 26, 2006 at 7:55 am
No, that's not what I was talking about.
In my case, I had a lookup going to a OLE DB Destination. I wanted to change that to go first to a multicast and then to either the OLE DB or a Recordset destination.
Anyhow, I found the answer. You have to highlight the arrow, delete it and a "new" (?) one will be generated which you can then re-connect to the new object.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply