Recursive Data Flow Renaming Output DataSet with "1" Rather than Input

Sam_Y

After running the ETL and Adding the Output as an Input, Existing Output is renamed rather than the Input.  Why is this occurring?  See attached.

GrantSmith

@user045611 

 

You can run it so the dataset will update the name (It's still the same dataset). After it's been run once you can then go back in and add the renamed dataset as your input and then change your output back to the correctly named version.

JennieElf

I may be oversimplifying but I had the same issue when I was building a recursive. Finally realized that I had to break the link between the Input DataSet and the Output DataSet BEFORE I dragged over the other Input DataSet which I would load with the Recursive Data Flow.  It's worked perfectly since I started doing that.

jaeW_at_Onyx

Try removing the input dataset.  Save.  Reload.  Does the output dataset rename? (remember you can always revert to a previous version of an ETL).

 

Also, you can alter your dataflow definitions using the javaCLI

https://www.youtube.com/watch?v=ysUHYaICYD8&list=PLUy_qbtzH0S4eYAu13c-NMnyOuxJwspzh&index=1

GrantSmith

@user045611 

 

You can run it so the dataset will update the name (It's still the same dataset). After it's been run once you can then go back in and add the renamed dataset as your input and then change your output back to the correctly named version.

JennieElf

I may be oversimplifying but I had the same issue when I was building a recursive. Finally realized that I had to break the link between the Input DataSet and the Output DataSet BEFORE I dragged over the other Input DataSet which I would load with the Recursive Data Flow.  It's worked perfectly since I started doing that.

Sam_Y

I stumbled upon this same thing today.  Thanks for the input!

Sam_Y

This also worked.  Thanks!