DSXchange

You could also substring from position 5 to the end of the string.

Suggest you clarify your requirement. Do you mean you need to substring off the first 50 characters of a 100 character string?

Not a big fan of using routines like that directly in triggers, prefer the Routine Activity stage.

That routine requires a job handle, not a job name, hence the need for a wrapper routine to establish it, get the link count, detach from the job and then pass back the result.

I think you'd need to open a case with your official support provider if you haven't already. You're right, this old DOS mechanism to count lines in a file works just fine from the command line. This is me executing one on Windows 7: D:\>findstr /R /N "^" c:\temp\bootstrap_log.txt | find /...

The post you quoted from rameshrr3 (which I removed from your post, please learn to just Reply) doesn't have anything to do with transformer looping. Not only does their solution not require any looping, it would be dead easy to implement.

So the short answer would have been yes.

What 8.x version are you on - at least 8.5?

Nope. It's a hard-wired limit.

Many did but not all. Have you tried setting APT_DUMP_SCORE to true and see if that information helps at all?

just4geeks wrote:Has anyone had any experiences with this kind of an error?

Did you try searching? That message returns 33 matches so it would seem to me your answer is 'yes'.

Pass in the proper credentials on the command line, user / password / domain.

You may also have a license limit on the compiler itself... say, one concurrent user and others wait.

prasannakumarkk wrote:You have to navigate to the datastage installation directory and in bin folder you have to invoke dsjob.

Have to? No. You just need to understand full v. relative paths and work with how your PATH environment variable is set up.

First, that is not a function but rather a stored procedure. And you do not have access to row data in any "pre" or "post" areas - that's why it works when you "hard code" the values and then fails when you try to reference anything orchestrate related. Lastly, there is...

The answer changes based on 32bit v. 64bit architecture. The former has a 2GB limit while the latter does not.