DSXchange

It's a CHAR field.

In other words, have your DBA do it for you.

That's not a problem, that's the Way It Works. Lookups by default return singleton results. At least this stage is telling you that is happening, most just do it silently.

If you actually want a 'multi-row result set' you'll need to move to a stage that supports that - either ODBC or UV.

tom wrote:is it possible to upgrade using the same license or else we have to buy the whole software with a new agreement.

Are you under maintenance? If so, you are entitled to the latest version at no extra charge, that's part of what you are paying for.

To be honest, I didn't notice the version number. I know the 'call' syntax works in 7.x but perhaps it doesn't in that version. Verify the format by searching the forum, there should be several conversations on the subject from what I recall. You don't want to go down the routine route. You'd have t...

I agree. I've seen the same issue in 6.x from what I recall as well.

It 'supports' and you don't need to import the metadata in order to call from the before or after sql tab.

Try it without the trailing semi-colons.

I was afraid of something like that. How does the Windows scheduler handle recurring jobs? Nothing like 'cron' out there?

Arnd is asking what happens when you put back (and re-register) the original version of the "jobseqpages.dll" file?

Do you have access to Ascential's Devnet, aka ADN? They have those items posted there, I do believe.

Since it happens randomly and on different jobs I've assumed that it down to the server being over-utilised at that particular time. Yes, that's exactly what that means. Especially when you say you have a multi-instance batch that kicks of "a bunch" of multi-instance jobs. You could take the time t...

Why not just include it in your file metadata in the Sequential stage and then promptly ignore it? Add another column at the end. Scroll over to the right and set the Missing Column attribute to one of the ones that doesn't say 'Error' or 'Warn' - like 'Replace'. Then it won't matter if it is there ...

It's a Windows command so best to look in Windows places for syntax and other help. For example, open a command prompt by clicking on Start then Run and then typing cmd as the program to run. Normal Windows syntax would be to type the command followed by a slash question mark to get 'usage' informat...

How are you scheduling your jobs? Strictly from the Director or is there a third-pary scheduler involved? For Director scheduled jobs, you could look into reading the control structures that Director leverages to schedule jobs - 'cron' / 'at' on UNIX or 'at' on Windows from what I understand. Unfort...

I have no idea what you are asking. Have you scheduled a job from the Director and you want to see what time it was scheduled to run at? Switch to the Schedule view in the Director (blue clock icon or View/Schedule from the menu) and it will show you which jobs in the current category are scheduled ...