Using TDP 4.2 64-bit on Windows 10
Am trying to see how to use Loop connections, but I keep getting an error.
- I create a fresh automation, and click on “Loop Connections”
- It puts the little box in the designer, and then I select 2 valid Excel connections.
- I tried doing execute script, which I assume will run against each conn from the loop? I could not find where to specify the loop-conn as a variable.
but no matter what activity I put in the loop-conn, it always gets this error
Loop_connections_1 - Object reference not set to an instance of an object.
I even tried it with NO activity enabled, or just LOG activity, but same error.
I can find nothing in any logs that gives me any hint what is wrong.
Tried both with the excel connections already connected, and NOT connected - same result.
My Local Storage db is started.
I am my wit’s end, no idea how to fix this.
I will likely just give up on automation ,i find it very picky and tricky and impossible to debug on my own.
I get so frustrated…!! And I found zero docs/helps about loop-connection. only stuff for loop-dataset.
Any advice what is happening? thanks