DSXchange

SQLTables is a function used by the API to retrieve a list of available tables in a database. Looks like, perhaps, its name is being translated to upper case by the (?) database server or the (?) calling mechanism. Or maybe there is a system function that you don't have privilege to execute. Check w...

I suspect you had an intermittent/transient OLE Automation issue in Windows, which may or may not recur.

Have you tried to? Is there one on the Palette for parallel jobs?

If it "has finished with a status of 2" then you don't need to stop it - it has already finished. The Job Activity through which you invoked the job needs to have an OK trigger leading to the next activity. That is sufficient to meet your stated need. I suspect you need some more thought, and anothe...

Every job that runs posts an event in the log (usually the second event for the job run) that reports the environment variable values actually used. The first event posts the parameter values used, so you can check which ones, if any, were altered.

I can't see them taking out COMMON - there are too many SDK routines that depend on it. But, then, I haven't played with version 8.x yet either.

If licensed, server jobs will continue to run quite happily. You may need to consider the actual migration process, however. For example do any hashed files (or a directory for them) need to be created on the new machine?

What is your business rule? That is, what should be the "numeric equivalent" of ""?

You can set up N instances of an always-running job. The web services will simply allocate any of the "free" resources. There is no more control than that, certainly no active load balancing.

Create the base file name then use an after job subroutine (perhaps ExecSH) to rename it.

Fourth, and best, option is to use DataStage. A standard lookup will not only determine existence but also return any columns from that row that you specify. Based on the success of failure of the lookup, you can make any further decision required such as setting a value in an IsValid variable or co...

Welcome aboard. :D You need to access SQL Server through the ODBC driver. Problem is, the one you have is not licensed for your use in code, only for use from the ODBC and Dynamic RDBMS stages. You will find that it works for 30 days, then fails with a message telling you to buy a licence from Data ...

Use a Column/Row Generator stage with job parameters for the limits.

Aborted is caused by some operational condition such as execution of the DSLogFatal subroutine or an appropriately severe condition being detected in the processing of data. Stopped is "stopped by operator", for example from Director or a call to the DSStopJob subroutine or Terminator activity. Cras...