DSXchange

I've found that NOTFOUND is always unreliable when used with anything other than hashed files as a reference input.

As noted, you need to remove any hidden Field Marks from the returned value before the number will compare properly. Use Convert to strip them from the output.

Interesting... not sure I would have thought of that technique.

Correct.

No.

Your expectations are wrong as you'll always get the filename after the count. Use 'cut' or some other mechanism to separate the count from the filename before it gets passed back out.

Hmmm... have you tried C_1578482926 = 'STARBUCK\'S' instead?

Do you actually mean Environment Variables? If you do mean stage variables, have you enabled their display on the new server? There's a button inside the transformation editor which turns them on and off, so to speak.

AFAIK, it's a manual process on their end and can take several working days to get finalized. There's nothing to download and about all I can counsel is patience.

Like that!

There is a pair of buttons at the top of the screen that only show up if you started the thread, one to mark as Resolved and the other Wordaround. Once marked, you then have the option to undo that choice.

Welcome! :D

Thanks for posting that. Actually, we've seen a number of odd problems posted here caused by running antivirus on a Windows based ETL server, it seems to eat things that upset running jobs.

Ok! Sounds like it is time to mark your post as Resolved.

Ok. Saying 'cartesian product' is misleading as that is not what you are after, it seems. Seems that you want to join two tables in disparate databases and get all records for matching keys - that's a normal inner join. You'll need to explain this statement: I tried to do this using a hash file look...

Nice. If this resolves your issue, please mark the post Resolved as well.

What are you considering 'special' characters in this case - the parens? What filename does it end up trying to open? Please post both the parameter value and what it resolves to inside the job - the actual values, not 'something like' the values.