DSXchange

Even the command line will require MSXML. I'd assumed you had that.

It only applies to Windows, which now uses a registry entry called ODBCINI.

I guess you could define your "ETL system" as an External Asset.

Good to meet you at IOD 2012. And thank you for the kind words there and here.

ORCHESTRATE is the name of a structure that holds the current row.

It does not make sense that ORCHESTRATE should be available to Before or After SQL statements.

What I wrote was correct at the time. When I return from vacation I'll check the behaviour and update my knowledge one way or the other. Or you may like to seek, and post here, a definitive statement from the vendor.

Go FIGure!

Only three years ten months later, with an identity change in the interim. Amazing!

Better use Oracle Connector stage to handle large volumes of data. It is 20% faster than OCI stage. 42% of all statistics are made up. Where did you get this figure? Are there any specified conditions under which the 20% was obtained? I could create jobs in which the OCI is faster than the Oracle C...

DSGetLinkInfo() takes a job handle, not a job name, as its first argument.
Therefore you probably need a routine activity rather than a user variables activity.

There are two uvodbc.config files; one in the DSEngine directory and one in the project directory. Is your DSN in the one that you haven't checked?

Use Convert() function in Transformer stage, as noted. If the file is fixed width you could change the definition of the final column to be one character smaller, then define a new, Char(1) column that contains the Ctrl-M, and use the "drop on import" property for that column. Or, of cours...

Each job log is a hashed file, with 32-bit addressing. The limit on the total volume of entries is, therefore, 2GB by default. How many actual entries this is depends on how large the various entries are. If you choose to convert particular log hashed files to 64-bit addressing, then the limit on vo...

There's a new addition to the Sequential File stage (and to the Big Data stage) in version 9.1 that does exactly this task.