Data Flow - Change Destination?

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

  • 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

  • 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