June 4, 2009 at 12:20 pm
I have an SSIS package that I am modifying and I need to adjust the workflow but I cannot see the connectors in BIDS to be able to delete and re-do my flow connectors. I know they are there because if I try to add a connector between the two existing objects where the connector already exists, I get a Microsoft Visual Studio error that states [Quote]Cannot create Connector.
Only one workflow can exist between the same two executables.[/Quote] I'm trying to figure out how to display them?
Anyone help me?
Thanks!
MJ
~mj
July 6, 2010 at 12:32 pm
Switch to the code-view (XML) of the SSIS package. You will have to determine the ID of the two elements that the program is complaining about -- the two you are trying to connect, no graphic, but the program says it already has a connection. Mine looked like what you see below. Find yours and just delete those lines. Afterwards, you will be able to connect the two elements normally with the GUI.
<DTS:PrecedenceConstraint>
<DTS:Property DTS:Name="Value">0</DTS:Property>
<DTS:Property DTS:Name="EvalOp">2</DTS:Property>
<DTS:Property DTS:Name="LogicalAnd">-1</DTS:Property>
<DTS:Property DTS:Name="Expression"></DTS:Property><DTS:Executable IDREF="{9965A405-F348-40C8-8AA2-18B728B6F849}" DTS:IsFrom="-1"/><DTS:Executable IDREF="{ADC5C4ED-65AE-4DF1-A100-9703BA947663}" DTS:IsFrom="0"/>
<DTS:Property DTS:Name="ObjectName">Constraint</DTS:Property>
<DTS:Property DTS:Name="DTSID">{7D675726-A0B5-46DC-9442-422B3FAFCC29}</DTS:Property>
<DTS:Property DTS:Name="Description"></DTS:Property>
<DTS:Property DTS:Name="CreationName"></DTS:Property></DTS:PrecedenceConstraint>
November 10, 2010 at 8:02 am
Try moving the task - this will often make the connectors re-appear.
January 19, 2011 at 3:31 am
caroline-599293 (11/10/2010)
Try moving the task - this will often make the connectors re-appear.
As quoted, just moving the task made the connectors re-appear 😛
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply