Dynamic Input In-DB Tool Issues

[suppahc]

So I'm testing performance and I'm having issues with the In-DB portion. I was able to run everything and it took 1.5 hours in total without using any In-DB tools. Now I'm trying to do a portion of the work In-DB and see if it cuts down on runtime.

I'm getting an error for a join: left and right side must have the same in-db connection.

My left input to the join comes from a dynamic input tool where the connection is New Server.

My right input to the join is a local file I'm using data stream in and creating a temporary file with the connection name new server. I've tried to rename it so that its New Server and still getting issues with this error.

[suppahc · Accepted solution]

So it appears that it is case sensitive. Didn't realizing my Dynamic Input In-DB name was all caps. Once I fixed that it worked.